Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Code This VFP IIF Statement In SQL
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01326128
Message ID:
01326131
Views:
13
>
>SQL doesn't like the 'OR's and 'AND's
<snip>
T-SQL doesn't like '.' (dots) arround them. There's no need to use dots in VFP either.
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