Hi,
I don't think SQL Server supports IIF() function. And I need to convert the following expression in my VFP-type SQL Select to SQL Server:
sum( iif( ( MYTABLE.STATUS = "O" or MYTABLE.STATUS = "C" ) and MYTABLE.TYPE = "AM", 1, 0 )) as OPEN_PM
How do I do it so that it works when passing the expression to SQL Server (via SPT)?
P.S. I forgot to change the default version of SQL Server when creating this message. I am using SQL Server 2005.
UPDATE/SOLUTION: CASE.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham