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

[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

 

[Lyle Fairfield]

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

Look up the whole CASE structure in Books On Line.

example:

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