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:52 am

    #1614248

    Sorry, here the the complete statement

    Select

    oppo_opportunityref

    ,oppo_stage

    ,oppo_closed

    From

    Opportunity

    Where

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

    Basically I'm trying to find all the Bus_Written opportunities where the closed date field is either null of within the last 7 days.