that english letter or french letter may come anywhere.

like i need to make search like that

select * from tbl_city where cityname like '%par%'

here, how can I find the...

hi,

i don't understand what you are trying to say...

you mean, i need to build two queries with union.

thanks

r.eswaran.