I am designing a query using OLE Db and SQL Server
When using the iif function I get an error says :"iif is not a recognize
function name".
When using Jet 4.0 with access the iff function works good.
Can someone help?
mail me to:

IIF is MS Access specific function and doesn't work on SQL Server.
I don't know, maybe there is a similar function on SQL Server, but I didn't
need it till now, so I'm not familiar with it. Try to look for some help in
MSDN or SQL Server Books Online.
It will be great if you could share me with the results of your search.

Good luck.
Vlad A.

Yoni,

As Vlad has posted, IIF is Access specific. The SQL Server, and ANSI SQL
standard, equivalent is the CASE statement which is documented in the SQL Server
7.0 Books Online.

Also, in the future please do not cross-post quite so extensively. Please limit
yourself to one or two newsgroups, and please try to target them a bit more
selectively. For example, I fail to see the relevance of
microsoft.public.vb.control.databound to your question.

---------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be
cut and pasted into Query Analyzer is appreciated.