Case statments that return values from a table

• barrabus

  SSC Veteran

  Points: 278

  More actions

  July 29, 2002 at 5:19 am

  #158752

  I am trying to migrate Access SQL to T SQL.

  I am migrating IIF staements using case statements .. I have encountered a problem in that some of the IIF clausew return a value from a column value as opposed to

  a 1 or a zero T SQL doesn't seem to be allowing me to do this.

  Any advice appreciated .

• sjcsystems

  Ten Centuries

  Points: 1347

  More actions

  July 29, 2002 at 5:30 am

  #433515

  I have done a similar thing migrating Foxpro to t-SQL.

  I assume you mean:

  declare @Foo int

  set @Foo=4

  select case when @Foo>3 then 'more than 3' else 'less than 3' end

  Some CASE statements can get hair-raisingly complicated if you have calculations conditional on results!!

• jmadren

  SSCrazy

  Points: 2055

  More actions

  July 29, 2002 at 5:48 am

  #433516

  You can return any column value as a result from the case statement, just like you're doing constants now. For example,

  Select col1, case when <some boolean condition>

  then

  col2

  else

  col3

  end as <somename>, col4, ...

  Jay

  
  Jay Madren