Is the IIF function supported in SQL 2005 CE?

[Guest]

I have ran this test in Query Analyzer 3.0.5040

Select a,iif(b>0,10,20) from mytable

I got an error with "not supported function" message.

Anyone can confirm me that this function is not supported?
Where can I find a list of supported functions in SQL 2005 CE?

 

[Alex Feinman [MVP]]

IIF is an operator supported in the DatColumn expression syntax but not SQL
syntax
The SQL Mobile reference is installed with Visual Studio 2005 Documentation

 

[Richard Thombs]

You could always use case, I know that's supported:

select a,case when b > 0 then 10 else 20 end