IF THEN question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jordan (nospam_at_bellsouth.net)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 12:45:00 -0500

I have what seems to be a simple problem that I can't solve.

The SQL statement selects a column called 'ConfirmedDate'.
If ConfirmedDate is null I want to display this column as RequiredDate + '
*'.
However, I cannot figure how to make this IF statement work:

strSQL = " SELECT DISTINCT Orders.OrderID, VendorName, ProjectName, & _
   " CONVERT(varchar, ConfirmedDate,1) AS ConfirmedDate, CONVERT(varchar,
RequiredDate,1) AS RequiredDate" & _
    " FROM Orders JOIN Vendors ON Orders.VendorID = Vendors.VendorID" & _
    " JOIN Projects ON Orders.ProjectID = Projects.ProjectID" & _
    " JOIN OrderLine ON Orders.OrderID = OrderLine.OrderID" & _
    " WHERE QtyOrdered > QtyReceived" & _
    " AND ConfirmedDate = '" & strTodaysDate & "'" & _
        " OR" & _
    " QtyOrdered > QtyReceived" & _
    " AND RequiredDate = '" & strTodaysDate & "'" & _
    " IF ConfirmedDate IS NULL SET ConfirmedDate = RequiredDate + ' *'" & _
    " ORDER BY ConfirmedDate"