Sorry, I thought you only wanted to get rid of the NULL.

We're using SQL2000 and we pass a NULL (without quotes) as a string if we want the date to be null.

NVL(DTOC(ldDate), 'NULL')


HTH,
Arriyel

>That still ends up trying to pass character data of '  /  /    ' into a date field.

Speak using soft and sweet words in case you have to eat them later.