IIF function not supported

[mp9]

Probably a stupid question...

I'm using a Transform Data Task to pump the results of a query out to an Excel spreadsheet. What I want to do is essentially this pseudocode:

If FieldA = -1 Then
Return TextStringA
Else If FieldB = -1 Then
Return TextStringB
Else
Return TextStringC

Now if I was using Access I'd use the IIF function in my query to do this but if seems the SQL in DTS doesn't support IIF. Is there are alternative I can use?

http://www22.brinkster.com/accessory/

 

[SQLDenis]

lookup CASE in books on line

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mp9]

Thanks, I was thrown by the Query Designer not supporting CASE but of course the query returns the right stuff, which is all that matters.