if else in a expression

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  December 4, 2008 at 11:29 am

  #194719

  Hey can you use and if else in a expression in a dervied column ?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  December 4, 2008 at 12:21 pm

  #907855

  Yes, but the syntax does not use IF or ELSE.

  It uses "?" and ":"

  @Var==1 ? "A" : "B"