Terri, Thanks a lot for the code sample. I updated the query based on your sample. It is working great and I dont have to worry about SQL injection. Thank...

In its current implementation, we cannot search for names with '. Thank you for pointing this. I will start looking into full text index.

as all the spaces and special...

Thank you for your reply.

It is a web based application and our users have always wanted the feature of searching their contact listing based on first name, last name or...