Thanks. Unfortunately, I can not include the column with the null date in a select statement.

Select

MemberID,

CASE

WHEN "Member DOB" IS NULL THEN Cast('No Date' As varchar(50))

  Else

     Cast("Member DOB" as...