Market com

Market com

  • 1.8k
  • 168
  • 2.7k

Sql server case statement in where clause

Nov 27 2020 9:11 AM
select * from table1 t1 where t1.active=1 and case when @x=1 then t1.name="" else t1.name<>"". please help to write it correct syntax 

Answers (7)