Using the Forumla option of the gui when creating a TABLE

• Pat Henz

  SSC-Addicted

  Points: 464

  More actions

  December 29, 2005 at 8:52 am

  #166952

  Hello all,

  Does anybody know where there is information about using the Formula option in the gui when creating a table or adding a column to a table?  What I'm basically looking for is what funcations  can and cannot be used in the Formula column. 

  For example can CAST be used or even using a CASE funcation be used?

  Thanks for any information.

• Jeff Moden

  SSC Guru

  Points: 1004592

  More actions

  December 30, 2005 at 1:02 pm

  #612211

  Pat,

  Basically, any legal expression may be used so long as it does not refer to another table.  Cast and Case may be used.  SELECT may not because it's a "clause" not an expression.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)