Create A column Formula

• deemo

  SSC Veteran

  Points: 297

  More actions

  October 2, 2003 at 10:51 am

  #83220

  Hello,

  can any one tell me how can i create a column fourmla that depend on other column.

  what i mean if i have a table with two colomen:

  col1

  col2

  if col1=1 then col2=Some value else col2=other value

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 2, 2003 at 1:22 pm

  #476857

  Use a CASE expression.

  SET Col2 = CASE Col1 WHEN 1 THEN SomeValue ELSE OtherValue END

  --Jonathan

  
  
  --Jonathan