Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Compound IIF To SQL Syntax
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01327969
Message ID:
01327972
Views:
11
VFP IIF() can be replaced with T-SQL CASE() function

>How do I do this in SQL?
>
>
>IIF(Trade.decTrade_Product_Balance <> 0 AND
>	(Trade.sTrade_Type_Pay_Rec = 'PAY' OR Trade.sTrade_Type_Pay_Rec AND Trade.sTran_Group_CD <> 'MAR'),
>		Transactions.decTrans_Amt, 0)
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform