Case Statement with not

• smriti.subramanian

  SSC Eights!

  Points: 854

  More actions

  February 9, 2011 at 2:14 am

  #142295

  hi,

  i want a case statement like this

  CASE suc.status WHEN IS NOT 'Completed' THEN 1 ELSE 0 END status

  here not is giving syntax issue...can u please let me know how can do this?

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 9, 2011 at 2:25 am

  #1284275

  errrm

  CASE suc.status WHEN 'Completed' THEN 0 ELSE 1 END

  ---

  
  Clear Sky SQL
  My Blog[/url]