Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
"David Mascorro" — — source: Informix-list mailing list archive (1991-1998)
Reply to: RE>Challenge!!!
I think if you use single quotes in your query that it will work.
select * from stock
where stock_code matches '14" Mono'Dave
dave@oncology.uthscsa.edu
--------------------------------------
Date: 12/6/94 10:49 AM
To: David Mascorro
From: Storm Software
Received: by stimpy.oncology.uthscsa.edu with SMTP;6 Dec 1994 10:47:34 -0700
Received: from rmy.rmy.emory.edu by pythia.oncology.uthscsa.edu (4.1/SMI-4.1)
id AA02065; Tue, 6 Dec 94 10:59:13 CST
Received: by
rmy.rmy.emory.edu (5.65/Emory_rmy.3.4.0) via MAILPROG
id AA16797 ; Tue, 6 Dec 94 11:51:38 -0500
Return-Path: ilist@rmy.emory.edu
From: storm@aztec.co.za (Storm Software)
Message-Id: <3c1tkq$h9e@ticsa.com>
Subject: Challenge!!!
Date: 6 Dec 1994 14:48:58 GMT
Reply-To: storm@aztec.co.za (Storm Software)
Organization: Aztec Public Access Internet
Sender: informix-list-owner@rmy.emory.edu
To: informix-list@rmy.emory.edu
X-Informix-List-To: dave@oncology.uthscsa.edu
X-Informix-List-Id: <news.10136>
Ok...I have a customer with a stock code of '14" Mono'. The challenge is
to execute an SQL statement that retrieves this row from the stock table.
Ok guys, I am sure you're all thinking along the lines of
select * from stock
where stock_code matches "14\\" Mono"
but that doesn't work.
Don't cheat now, I want to use 'matches' because I could be searching
for 14" anythings and you can't use '?' for the quote.
The challenge is there...
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.