Case (in)sensitive

From: Boszormenyi Laszlo <gcs(at)jupiter(dot)hlab(dot)uni-miskolc(dot)hu>
To: pgsql-novice(at)hub(dot)org
Subject: Case (in)sensitive
Date: 2000-09-23 16:23:37
Message-ID: Pine.LNX.4.21.0009231821150.26885-100000@jupiter.hlab.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello!

I have a database with city names, so the first letter is capitalised.
I want to let the user search for part of the city name. How can I do case
insensitive for this? You know "... like '%bud%';" won't find Budapest.

Thanks in advance,
Laszlo Boszormenyi

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Claus Houmøller 2000-09-23 17:41:01 Re: Case (in)sensitive
Previous Message Tom Lane 2000-09-23 16:20:07 Re: [SQL] how to store a query, that results in a table