Hi,
In my table there is a coloumn Location in that column there are so many rows filed with Bangalore, chennai.....like that
in frot end there is a search by location one textbox is there
in textbox if he enters B means all bangalore, bihar like all b values will come and he enters bangalore, chennai, hydrabad, delhi then all 4 values will come How?

If you are just looking for the sql to return those rows it would look something like   select Location from TableName where Location like VARIABLE+'%'