Is the IIF function supported in SQL 2005 CE?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
You could always use case, I know that's supported:

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