Hi, I have a condition (with a parameter named @Par1=IS NOT NULL) in query like this select * from table1 where Numeric field1 IS NOT NULL. It runs okay but where numeric field1 =@Par1 it, it doesn't work.
@A= '>0' and @invcode = 1
SELECT GoodCode, Stock
WHERE (Stock = CASE @invcode WHEN 1 THEN @A ELSE <0 END)