Autocomplete SQL, requesting advice?

Autocomplete SQL, requesting advice?

I'm having a problem with an autocomplete that my ASP.NET developer is having a hard time doing, is jQuery suitable to get the following done and how or directions on where to proceed.

I have a SQL contacts table and I want the autocomplete connected to it. In order to remove ambiguity for the user I need the following behavior.

1. When a user enters T or C or B the drop down would show any records that the business name starts with those letters, Ex: The Color Box (may be at several locations) and C would return Color Effects and The Color Box.

2. The drop down results would also display the rest of the record. Ex: The Color Box, 123 Main Street, Fairfax, Virginia, 21015 333-222-2222 etc.

Or:

The Color Box
123 Main Street
Fairfax, Virginia 21015
333-222-2222

http://handofflogistic.com/

http://handoff.notableapp.com/website-feedback/136673/HandOffLogistic-New-Order

Thanks