T-SQL and the WHERE LIKE %Parameter% clause

January 4, 2023 by Tarik

It should be:

...
WHERE LastName LIKE '%' + @LastName + '%';

Instead of:

...
WHERE LastName LIKE '%@LastName%'