Querying for names
- by Sai
I have a table (say "Demographics") on SQL Server. In this table are the following columns "LastName", "FirstName", "MiddleName", "Prefix" , "Suffix".
I have one textbox to search for them on a webpage. My question:
Whats a good design strategy for queries where the user could be searching for various combinations of names including last names…