>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 :(