I'm trying to use the function IIf in a view in SQL SERVER 2005, but I get a message "IIf is not recognized as a built-in function".
How can I make it work, or at least see a list of all the built-in functions?
Your DB --> Programmability --> Functions for all built-in functions
|||You need to use CASE in SQL Server (which is not the same as IIF in Access). You can search (SQL CASE) to find how to use it.
