Re: Case sensitive "like"

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 7 May 1999 20:00:51 +0200
Message-ID: <7gv9nt$l0t$1@weber.a2000.nl>

gerard wrote
> I want to avoid using "where lower(name) like 'fred'"

Just to be sure: you know you should use some wildcards to make the like do its job? Like:

where lower(name) like 'fred%'

Ohhh, now I get the picture. You just want a case-insenstive comparisment, not a search. Then you should indeed use

where lower(name) = 'fred'

or, of course,

where upper(name) = 'FRED'

Arjan. Received on Fri May 07 1999 - 13:00:51 CDT