autocomplete extender

[Jagz W]

i am using autocomplete extender with database. the text property for autocomplete extender is a concatenated string e.g First Name + '-' + Last Name Now my problem is when i type first name it works fine but when i start typing last name nothing comes because the wildcard char is on first name e.g where Firstname like 'abc%' (sql query) now i want the wildcard on firstname + lastname I hope u understand the problem Jagwinder Singh.

One person's data is another person's program. --J.Walia