How to find record having % as part of data.

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.