I have a query like this:
declare @firstname varchar(30);
declare @lastname varchar(60);
if the user passes in first name I want to return that. if they pass in lastname I want it to return that. it is possible that they might pass in first and lastname or just one of the two. What would be the best way to write the where clause? It is also possible that they will pass in only part of the name.