P K

P K

  • NA
  • 284
  • 57.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)