Search

Using a windows form in VS.net I am trying to create a form where the user can input the name of the person he or she is searching for and the DB would return all the fields in that record.

I can easily set up the fields but what do I need to putin so the table does not fill itself with all the names in the DB (over 200 000)

Do I use wild characters or is there a SQL or T-SQL format to use for searching SQL 2000?

Thanks in advance for any help.

Albert