>>I don't understand why my code isn't working as I use the identical technique in another SP and it works wonderfully
>
>But this works:
>

>DECLARE @Test TABLE (Fld1 NVARCHAR(50))
>INSERT INTO @Test VALUES ('WLIF20120047')
>DECLARE @LikePerc nvarchar(50)
>DECLARE @LikeWoPerc nvarchar(50)
>SET @LikePerc = 'WLIF20120047%'
>SET @LikeWoPerc = 'WLIF20120047'
>SELECT * FROM @Test WHERE Fld1 LIKE @LikePerc
>SELECT * FROM @Test WHERE Fld1 LIKE @LikeWoPerc
>

Maybe I've worked too hard today, but I'm not getting your point :(