>Hi All,
>I'm baffled by what should be a simple thing. I'm trying to use a parameter in a WHERE clause.
>A dirt simple example might be:
>
>declare @Arg varchar(20)
>SET @Arg = 'Joe%'
>
>SELECT * FROM Table WHERE Name LIKE @Arg
>
>I get nothing back from the above while SELECT * FROM Table WHERE Name LIKE 'Joe%' works like a champ.
>
>Clearly, I'm new to doing this. I really want to avoid dynamic SQL here!
>
>Any help is appreciated.
>
>Gary

Don't think there's anything wrong in principal. Is the above an actual example ? If @Arg is dimensioned less than the string length assigned to it then you'd get nothing back.