Home Forums SQL Server 2008 T-SQL (SS2K8) IS NULL in a Case Statement RE: IS NULL in a Case Statement

  • May 10, 2013 at 9:42 am

    #1614238

    ssmith 29602 (5/10/2013)

    This is probably very simple but I can't get it to work.

    If trying to write this

    Case Oppo_stage When 'Bus_Written' Then (oppo_closed is null or Oppo_Closed >= GETDATE() -7)

    but I'm being told there is incorrect syntax near the keyword 'is'

    Can anyone help?

    many thanks.

    Yep bad syntax. Unfortunately with what you posted there really isn't much to go to help. Perhaps if you posted the entire query we might be able to figure out what you are trying to accomplish.