I need help recoding this one segment .....
I am currently getting back a '1900-01-01 00:00:00.000' when the ELSE IsNull(pi.birthdate,'') should have reported back nothing. Can someone assist me?
CASE WHEN COALESCE(pi.InsuredSameAsPatient,1) = 1 THEN pp.birthdate
WHEN COALESCE(pi.InsuredSameAsGuarantor,1) = 1 THEN g.birthdate
ELSE IsNull(pi.birthdate,'') END