Re: Challenge!!!
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...