Hi All,

I'm trying to convert the following query to Oracle. But I don't know how to convert my NULL dates. ( Start_Leave & End_Leave )

SELECT PERS.email_addr,
PERS.pers_no,
PERS.Last_name,
PERS.first_name,
NVL(EMP.start_leave, {}) AS start_leave,
NVL(EMP.end_leave, {}) AS end_leave
FROM PERS,
EMP,
EMP_ROLE
WHERE EMP.pers_no = PERS.pers_no
AND EMP.pers_no = EMP_ROLE.pers_no
AND RTRIM(EMP_ROLE.ROLE_CD) = 'EMP_DATA'
AND EMP.out_dt IS NULL

TIA
Mike

P.S. VFP6 SP5 Oracle 8i