Can you post-process file and change "||" to "| |" and "|" + CHR(13) to "| " + CHR(13)?
>I'm using the following syntax:
>Copy To ( < file name > ) FIELDS < FieldList > Delimited With "" With Character "|".
>
>If the field is 1 character in length it seems to preserve that space but any field greater than one character strips all the spaces and I end up with a NULL when trying to Bulk Insert info SQL Server.
>
>I can't use fixed length. I have to use a delimiter.
>
>Is there a work around for this problem?
--sb--