> Similar to my earlier SQLCMD/OSQL question, I have some BCP commands
> that I need to run on SQL Server 7. The command produces pipe-
> delimited output, but that's just an override on the separator
> character, and in SQL Server 7 <NULL> values come out as a single
> space, whereas in SQL Server 2005 they come out as an empty value. It
> turns out that this isn't a problem as the system that receives the
> data trims trailing spaces anyway, but I'd like to know if there is a
> way to tidy this up.
>
> My commands look a little like this:
>
> bcp %database%..%table% out %table%.txt -c -t"|" -U %user% -P %pw%
>
> I have tried the -k "keep NULL values" parameter but this makes no
> difference.