Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with MAX function in SQL statement
Message
From
04/11/2005 12:18:25
Sergey Berezniker
New York, United States
 
 
To
04/11/2005 09:02:47
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Problem with MAX function in SQL statement
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01065034
Message ID:
01065512
Views:
19
in T-SQL you can CASE function.

>
>What would one use in T-SQL to do as he asked?
>
>>No you cannot use VFP MAX() function in SELECT. You can emulate it with IIF() or ICASE().
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform