I have been operating from MS Access and have now upgraded to MS SQL 2005, in Access i could use a IIF Function in the creation of a veiw, in 2005, the function is there but it appears that it is only available to MDX queries, is this assumption correct and if not, what is the syntax for the function.