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