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 that have spaces
e.g. "Smith James Jr." . Our customers store Jr. sometimes in suffix and sometimes just tack it to lastname. Sometimes Smith James Jr could be the entire last name.