Hello arun, ak> how to do a case insensitive search on postgresql database. i will ak> enter a keyword in text field and it has to search for that keyword in ak> keywords field of table and should be case insensitive. why don't you use "ilike" to search for the pattern in the database. -- Best regards, Gurudutt mailto:guru@xxxxxxxxxxxxx Life is not fair - get used to it. Bill Gates