I'm reading a table that has 3 dates, closed, promoted and cancelled. Any or all of these dates can be populated or null. I need to find the earliest date or null if there are none and use this result in comparisons with other dates. Can this be done in SQL or should I create a query to fill an extra column with this date?