Post reply

using case in where clause

  • October 16, 2014 at 9:50 am

    #291024

    I am trying to do the following: Check if the inspection != 'value', if it doesn't filter using where, otherwise no filtering is necessary.

    This obviously doesn't work as case need to return a value, but something to the effect of:

    select * from table

    case when inspection != 'permit' then where OverDue is not null end

    Any ideas?

    Thanks

  • October 16, 2014 at 9:57 am

    #1752912

    where

    inspection='permit' or

    overdue is not null

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • October 16, 2014 at 10:19 am

    #1752916

    Well now I just feel stupid. 🙂

    Thanks for the help Matt.

  • October 16, 2014 at 10:22 am

    #1752917

    bubs (10/16/2014)

    Well now I just feel stupid. 🙂

    Thanks for the help Matt.

    Oh I have my share of those 🙂 . Don't feel that way - it's usually a matter of staring at something for too long!

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply