I am trying to figure out a way to evaluate 3 different date columns and select the lowest time value. I also have NULL's in these fields
A b c
1/1/2010 1:51 1/1/2010 13:51 1/1/2010 14:00
NULL 1/4/2010 11:01 1/3/2010 11:00
so for the first row the date value from A should be returned, and in the 2nd row the date value from C should be returned.
Thanks in advance!