If file is not to big, you can STRTRAN empty dates to nulls.
STRTOFILE( STRTRAN( FILETOSTR("test.txt"), "/ / : :", "Null"), "Testnull.txt")
>We are using the following command to create the text file for a SQL bulk insert:
>
>
>Copy To < filename > Delimited With "" With Character "|"
>
>
>We need to be able to propagate nulls for datetime into the SQL but these are being converted to empty datetimes in the text file.
>
>We can change nulls to a bogus date like {12/31/9999 12:00:00 AM} and reconvert to null once the data is brought into SQL.
>
>Is there a way to preserve the null values as part of the copy to?
>
>TIA
--sb--