Viewing post 1 (of 1 total)
Tried out this:
DECLARE @COLOR VARCHAR(20);
SET @Color=NULL
select ID,Color from TBLCOLOR
WHERE ISNULL(Color,'') like '%'+ISNULL(@COLOR,'')
January 29, 2013 at 11:30 pm
#1582477