Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Code This VFP IIF Statement In SQL
Message
From
23/06/2008 12:20:26
Sergey Berezniker
New York, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: How To Code This VFP IIF Statement In SQL
Miscellaneous
Thread ID:
01326128
Message ID:
01326129
Views:
11
>How do I put this in SQL syntax:
>
>
>IIF(((TRANCODE="PR") .OR. (TRANCODE = "PT" .AND. TRANQUANT > 0)),TRANQUANT,0) AS Recepit
>
CASE WHEN (TRANCODE = 'PR') OR (TRANCODE = 'PT' AND TRANQUANT > 0) THEN TRANQUANT 
     ELSE 0 END AS Recepit
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform