non-case sensitive

[danijela]

Hi,
does anyone have an idea how to make non case sensitive search in db?
im using postgreSQL and i need when i write something in my text box that gives me the right query.
example:
In database i have some towns:
Zagreb
Split
etc.

and I want when I write zagreb or zaGreB that gives me the right query from DB.
same for other towns.

tnx

danijela

[danijela]

solved
i found a function in postgresql
search case insensitive: SELECT subject FROM topics WHERE subject ~* 'JBUILDER';