Function in a ADP similar to the IIF Function in a MDB

  • Thread starter Thread starter John Botha
  • Start date Start date
J

John Botha

Hello

Can anybody tell me how I can get a similar effect
in a view or sp as with the iif function in a MDB.

It seems that there is only a multiline If function
in Transact Sql

Thanks
John
 
Can anybody tell me how I can get a similar effect
in a view or sp as with the iif function in a MDB.
Click to expand...

Look up the whole CASE structure in Books On Line.

example:

CASE StaffComponent WHEN 'Adjustments' THEN ISNULL(StaffFTE,0) ELSE 0 END
 
Back
Top