Upper and Lower case sensitivities

From: "Campbell, Scott" <scampbell1(at)mtt(dot)ca>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Upper and Lower case sensitivities
Date: 2000-08-30 12:20:27
Message-ID: ED7A447524CCD311A9BF009027DC86ED011E39FB@NSEXCH02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey,

Is there a function within postgres that lets you search for both upper and
lower case at the same time?
I know of the upper() and lower() functions but if a word has both upper and
lower case in it it won't be returned by a query.
Or am I limited to forcing my data to have one case only?

Thanks
Scott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Heaven 2000-08-30 12:43:31 Re: Upper and Lower case sensitivities
Previous Message g 2000-08-30 11:56:31 Re: table count limitation