CODE EXAMPLE FOR SQL

T-SQL and the WHERE LIKE %Parameter% clause

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