IIf function

[Anfel]

I'm trying to use IIF function inside Select statement and getting errors. It's very simple statement: I need to see PhoneNumbers if TelephoneType <> '13', and if TelephoneType = '13' field PhoneNumber should be empty. I'm getting errors and I'm lost.

Thanks in advance

 

[r937]

where access uses IIF, sql/server uses CASE

select case
when TelephoneType = '13'
then ''
else PhoneNumbers
end as PhoneNumber

rudy

http://rudy.ca/