Challenge!!!
Posted in 1994
Storm Software — — source: Informix-list mailing list archive (1991-1998)
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...