I have a field 'NAME' that can contain first and last names.
I would like to have a textbox that can collect a submitted last name to perform a search....something like :
Select * FROM tblCustomers
WHERE NAME LIKE '%SMITH'
This would return all John Smith, Fred Smith and so on...
I have a stored procedure that will be referencing a textbox called 'txtNAME'. In my where statement how would the wildcard look? NAME LIKE '%' + @NAME ? (@NAME is the declared variable)