Dates Fields


  • I have a select statement with several columns.  3 of the columns are dates and I am creating a 4th column that I need those dates in.

    Column A = Date 1

    Column B = Date 2

    Column C = Date 3

    Not all the columns have dates so what I want to do is a case statement for                                                                         Column D = case                                                                                                                                                            when Column A is not null then A, when if A is null then look at B, if both A and B are null then C is the default.

    How can this be done? 

    Saturday, February 15, 2014 3:38 PM


All replies