IIF in SQL-Statements / views / stored procs 1

[pharcyder]

Hello,

we're transferring our Access Database to an ADP-Project,
thus were not using the queries in Access but views in SQL-Server.

The problem is that the function "iif" is not working in views / stored procedures.

I need a column where either 'NULL' or text is saved to give back 'Yes' or 'No'. In Access-SQL it worked like this:
Iif([fieldname] Is Null, "No","Yes&quot

Can I perhaps write a function to give this special column back and use it in a view or is there any other way to "convert" one column basing on the source-column ?

TIA,
Jens K.

 

[sunila7]

Hi,


u will have to use CASE statements instead of IIF statements...

u can find info about case statement in this link....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5t9v.asp

Sunil

 

[pharcyder]

Thanks, that was a superfast answer, just 5 minutes after I posted mine

Greetings from Germany,
Jens