Re: Challenge!!!

Re: The challenge is there... What about select * from stock where stock_code matches "14\\"" Mono" ^^^^which does work. Note the extra quote and the space between the second quote and Mono. Cheers, Peter -- Peter K. Botcherby e-mail : p.botcherby@umds.ac.uk Paediatric Research Unit Guys Hospital, London, UK. > >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... >