How can I pass variables to select statement 1

[crasho2001]

I have following statement in my stored procedure. From first two rows I can see the values for variables.

"where ce = @ce" is also working. But " (id not like "{@bc,%" or id not like "{%,@bc,%" or id not like "%,@bc}&quot " is not working.



How can I pass @bc to " (id not like "{@bc,%" or id not like "{%,@bc,%" or id not like "%,@bc}&quot " .....



select @ce

select @bc

select bs,ce,bc,id from int where ce = @ce

having(id not like "{@bc,%" or id not like "{%,@bc,%" or id not like "%,@bc}&quot

 

[dickiebird]

String 'em together with +
eg
and not like @bc + "%" and not like "%" + @bc

HTH

Dickie Bird (-)))