IIF function in query 
Author Message
 IIF function in query
We are migrating some of our data that is currently stored
in an access database, and in one of those queries the IIF
functions are used. When I attempted to migrate those into
SQL I received the following error "IIF is not a
recognized function name", Is it possible to use the IIF
function in a standard select query?

                      thanks,
                         Steve



Wed, 30 Jun 2004 04:31:59 GMT
 IIF function in query

No, use CASE instead:

CASE WHEN <condition> THEN <statement1> ELSE <statement2> END

--
Zach
---
When in doubt, check out the Books Online,
  it's a GREAT source of information!


Quote:
> We are migrating some of our data that is currently stored
> in an access database, and in one of those queries the IIF
> functions are used. When I attempted to migrate those into
> SQL I received the following error "IIF is not a
> recognized function name", Is it possible to use the IIF
> function in a standard select query?

>                       thanks,
>                          Steve



Wed, 30 Jun 2004 04:51:17 GMT
 IIF function in query
http://www.aspfaq.com/show.asp?id=2214


Quote:
> We are migrating some of our data that is currently stored
> in an access database, and in one of those queries the IIF
> functions are used. When I attempted to migrate those into
> SQL I received the following error "IIF is not a
> recognized function name", Is it possible to use the IIF
> function in a standard select query?

>                       thanks,
>                          Steve



Wed, 30 Jun 2004 05:15:17 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. IIF function in sql statement equal to what is used in Access-Query

2. IIF Function simulation in update queries??

3. Using IIF Function in Sql Server 2000 Query ?

4. IIf function for this Microsoft Access query?

5. IIF Function not recognized as valid function

6. IIF function

7. TSQL equivalent of IIF function

8. IIf Function ???

9. IIF function on SQL Server?

10. iif function in views

11. how can I use IIF function in sqlserver

12. Functions like iif or decode


 
Powered by phpBB® Forum Software