IIF problem

[TheFoZ]

Hi I'm trying to use the Iif function. I've had a look on MSDN and it seems like it is valid in SQL server express but I get an error saying that there is an error near the = sign in the Iif function. I'm using IIF(IsConsultant = -1, 'Yes', '') AS Consultant which is giving me the error. Am I using the wrong function for SSE or am I doing something wrong. The data type for the IsConsultant field is int Many thanks

The FoZ

[Pete OHanlon]

In SQL Server, you have the CASE statement to do this:

SELECT CASE IsConsultant WHEN -1 THEN 'Yes' ELSE '' END AS Consultant

Deja View - the feeling that you've seen this post before.

My blog | My articles

[TheFoZ]

Thanks for that. Its something the book I've got didn't touch upon.

The FoZ