Re: case insensitive searches
From: Randy Dewoolfson <randyd_at_cais2.cais.com>
Date: 1995/07/19
Message-ID: <3ujekn$319_at_news.cais.com>#1/1
Date: 1995/07/19
Message-ID: <3ujekn$319_at_news.cais.com>#1/1
Anthony Sama (asama_at_netaxs.com) wrote:
: What's the best way to specify case insensivity in a WHERE
: clause?
To match strings withou regard to case you might try WHERE UPPER( string1) = UPPER( string2 ) or the LOWER equivalent..
Hope it helps
Randy :)
-- ..uu. ---------------------- .?$" '?i . I Randy DeWoolfson I .T^M ._at_" d9 . f ,.un. b, i I--------------------I " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I & 'M ,P `E M "$ Mux~ n!` I |o o| I dk `h" ' j " y" *~ I====oOO==(_)==Ooo===IReceived on Wed Jul 19 1995 - 00:00:00 CEST