Re: Case sensitive "like"

bvalent wrote
>you will need to do an UPPER, not a LOWER.

Ehhh, I indeed always use upper, but why shouldn't I use lower?

    where lower(name) like 'fred'

seems OK to me (except for the fact that no wildcards are present in 'fred' ... )

Arjan. Received on Fri May 07 1999 - 12:56:44 CDT