Want a cool sig (11/29/2012)

---

dilipd006 (11/29/2012)

---

Thanks dave

Is there any performance issue if i create Filterindex for each AlternateCityName column.

I want to load thi city in a text box while typing the characters.If i i use ur SELECT statement it will display result from all the 3 clolumns which i don't want..i only want the matching characters from the respective column.

Sounds like you're trying to do an autofill on a text box as a user starts typing. If that's the case you'd get the entire list of city names and load it to a dataset in memory and have the application do the autofill function instead of querying the database each time the user types a character...