>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
