Hi, I am having problem retrieving data with % in the value. I tried a lot but so far i have no luck. for example i have first name = 'abc', middle name = 'pq%', last name = '123' I want to list all the entries that ends with %. Because those are wrong entries and i want to remove % from the middle name and retain 'pq' only. Any help is very much appreciated. Thanks Biswa. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance