Re: Challenge!!!
storm@aztec.co.za (Storm Software) writes:
>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.
select * from stock
where stock_code matches '14"*'
will work because the single quotes will take the place of the doubles.
David
David Coburn coburn@informix.com
Informix Software, Inc. ...uunet!infmx!coburn
=========================================================================
Any opinions expressed here are not necessarily those of Informix
(or for that matter, anybody else).
=========================================================================