Post reply

Can I write an If statement in a view?

  • August 31, 2004 at 3:01 pm

    #163127

    I am trying to write an If statement in a view, but can't seem to get it right.  Does anyone know how I can accomplish this.

    Basically, I want an if statement that will see if there is a value of "x" in the field, if there is, I want it to write "Yes", otherwise I want it to write "No".

    Any help would be appreciated.

    Thanks

    Michelle

  • August 31, 2004 at 3:51 pm

    #521284

    check out the case statement

    CASE

  • August 31, 2004 at 3:53 pm

    #521285

     

    one more time rocky:

    CASE WHEN colname = "X" THEN "Yes" ELSE "No" END as newcolname

    BTW: do you have infinite jest and excellent fancee?

     

     

  • September 2, 2004 at 6:41 am

    #521492

    Thank you for your help.  I'll definitely give this a shot.

    Michelle

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

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