Re: Challenge!!!

In article <3c27ra$qbp@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: > Gosh, I wish all the questions were this easy. You ruled out > using ? in the MATCHES clause, so there are two 'obvious' answers. > > -- ANSI compliant > SELECT * FROM stock WHERE stock_code MATCHES '14" Mono';> -- Informix extension > SELECT * FROM stock WHERE stock_code MATCHES "14"" Mono";> > If you needed to be ANSI compliant and to select a 14 foot Mono-hull, then > you'd use: > > SELECT * FROM stock WHERE stock_code MATCHES '14'' Mono-hull'; Hi Jonathan, I still thought that MATCHES is NOT ANSI compliant (use LIKE instead)... :-) (sorry, but I couldn't resist...) Greetings from Munich, Alexander -- Alexander Koerner @ Informix Germany Oskar-Messter-Str. 25, 85737 Ismaning Tel.: +49 89 960 980 Fax: +49 89 960 98 500 Email: alexk@informix.com (NeXTmail accepted!)