Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this:
CREATE PROCEDURE SPFIND
WHERE FIELD1 LIKE '%@VARIABLE1%'
Then to execute the procedure,
EXEC SPFIND 'VARIABLENAME'
I can't get this to work using the LIKE operator. I would appreciate any help.
SQL Server 2005
June 7, 2010 12:38 PM
June 8, 2010 7:26 PM