No and they will not work this way in VFP either. You can use IIF()/ICASE() in VFP and CASE function in SQL Server.


>I have a SQL table with dates in 3 columns. I'm writing a query and I want to get the earliest date from the 3 columns as 'StartDate', and the latest of the dates in the 3 columns as 'EndDate'.
>
>Is there the SQL equivalent to the VFP Min() and MAX() function?
>
>Example:
>
>select min(DateCol1, DateCol2, DateCol3) as StartDate, max(DateCol1, DateCol2, DateCol3) as EndDate from ...
>
>I've been looking, but can't find anything.
>
>Thanks,
>Larry