IIF equivalent in SQL 2000 2

[hsingh1981]

Hi all,

I have this iif statement but i can't find the equivalent in sql....

Action: IIf([Action] Is Null Or [Action]='',Null,'Action: ' & [Action])

What would that be in SQL Programming?

cheers

 

[danvlas]

case when coalesce(action,'')='' then null else action end

or...shorter:

nullif(action,'')




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jondow]

As an add on to Daniels solution you can also use:

(case
when coalesce(action,'')=''
then null

when coalesce(action,'')='something else'
then 'another output'

else action
end) action

Which is the alternative to nested iif statements.

 

[hsingh1981]

Brilliant thanks guys