Re: Challenge!!!

Alex, It's a fair cop, guv! (Which, being translated, means "You're right!") Happy Christmas to you, and everyone else who reads comp.databases.informix. I'm going off-line from the end of business today until the New Year. It's called a holiday where I come from (and am going to be visiting), and a vacation where I live. Either way, I won't be paying attention to email or comp.databases.informix for about 3 weeks. I hate to think what my mail box will be like when I get back! Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: alexk@infmuc.informix.com (Alexander Koerner) }Subject: Re: Challenge!!! }Date: 9 Dec 1994 13:00:01 GMT }X-Informix-List-Id: <news.10205> }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!)