-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, Jan 02, 2002 at 05:18:31PM -0600, Tomasi, Chuck wrote: > Is there a way to get LIKE to be case-insensitive?
This will do What You Want: SELECT foo FROM bar WHERE LOWER(baz) LIKE '%quux%'; And an Oracle performance note: create a function-based index on LOWER(baz), otherwise you'll likely be doing a full table scan every time you execute this. Ick. - -- Stephen Clouse <[EMAIL PROTECTED]> Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. <http://www.theiqgroup.com/> -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQA/AwUBPDPDKQOGqGs0PadnEQIs3gCg293dmlulXoqXtz1aW8LvwV2BNoMAmwdq r0S73sRyliG4xXWfZ0s2FcCV =6mVI -----END PGP SIGNATURE-----
