If statement in SQL7 View (IIF) 
Author Message
 If statement in SQL7 View (IIF)
Is there a way to use something like the Access IIF in SQL views?
Example:
IIf(AB='a',1,2)


Wed, 04 Dec 2002 03:00:00 GMT
 If statement in SQL7 View (IIF)

CASE
        WHEN AB = 'a' THEN 1
        ELSE 2
        END

On Sat, 17 Jun 2000 05:54:14 -0400, "Norman Simoneau, Pres."

Quote:

>Is there a way to use something like the Access IIF in SQL views?
>Example:
>IIf(AB='a',1,2)



Wed, 04 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to se IIF or Case statements in a view to create a column

2. Does SQL7 have an equivalent IIF function (Access 97)

3. Failed to view a table or view from SQL7 Enterprise Manger

4. Failed to view a table or view from SQL7 Server Enterprise Manager

5. SQL7 bug-2nd query in a T-SQL statement with a compute statement loses headers

6. iif functions in views / procedures

7. Using IIF in a View

8. IIF FUNCTION IN A VIEW

9. iif function in views

10. How to use IIF function in a view

11. IIF function in view ???

12. equivalent for IIF (in VIEWS)


 
Powered by phpBB® Forum Software