Hi Tom,
Substitute 'DTOC(NVL(m.DOB, {}))' for the
"TO_DATE('" + DTOC(m.DOB) + "','MM/DD/YYYY'), " in your string.
HTH,
Arriyel
>I don't follow...
>Also forgot to mention this is FoxPro 5.0
Speak using soft and sweet words in case you have to eat them later.