Here i want to split the CustNm values from table with spaces and search with each word. how to do that? If i type" ba" in textbox it should display only values starting with ba
eg
Bakers
Home Bakers
State bank Of India
Not Abad Homes (This should not list)
How to change the query?
[WebMethod]
public static List<string> GetAutoCompleteDetails(string custdetails, string city) Go to the complete details ...