Figure 5. Pass in the Smith String When you run the usp_clr_GetFilteredContacts stored procedure and pass in the string "Smith," you see that the stored procedure returns the rows within the Person.Contact table that have "Smith" anywhere inside the LastName column. The stored procedure only returns the columns LastName, FirstName, and EMailAddress for visibility purposes.