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?