Please help me in little SQL select syntax

[Tabish Siddiqui]

hello all,

I have countries name stored in database along with comma and other characters like ( ) ] }.... and when i am perfrming a search i am sending country name without any special charecter added.. for example..

"Micronesia, Federated States of" is a country name and when i am searching i am passing this name as "Micronesia Federated States of" without any comma..

Now i was using like statement but it is not matching and giving any result..

i was wrting syntax like

Select * from country where country_name like '%$country_name%'

Please help me..

Regards



Edited 1 time(s). Last edit at 04/28/2005 08:05AM by Tabish Siddiqui.