Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using CASE within SUM()
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01035999
Message ID:
01036038
Views:
12
>>Del,
>>
>>You're missing comma after previous column and I would use BETWEEN operator for readability. I made corrections below in the code.
>
>Thanks for the catch. And I'm glad BETWEEN is also allowed here - I will use that as well.

T-SQL is more consistent than VFP in that respect. If you can use some operator in the WHERE clause, you can use it anywhere where such expression is allowed.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform