Can I write an If statement in a view?

• myorick

  SSC Enthusiast

  Points: 118

  More actions

  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

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  August 31, 2004 at 3:51 pm

  #521284

  check out the case statement

  CASE

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  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?

   

   

• myorick

  SSC Enthusiast

  Points: 118

  More actions

  September 2, 2004 at 6:41 am

  #521492

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

  Michelle