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