Hey,
try a: "select * from city where lower(name) like '%bud%';", that should
give you the name, of this nice city...
Claus
Boszormenyi Laszlo wrote:
>
> 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