bcp

[bobk5444]

hello,
when i run a bcp using:

... out -c t'|'

the downloaded data contain spaces in the output format ie:

"abcde |" instead of:

"abcde|"

any way to remove the spaces?

Thanks very much!
BobK

 

[mrmitchmitchell]

when you write your query you can use the TRIM() function on that column

 

[bobk5444]

ok good idea thanks for the tip!

have a great week and thanks for taking the time to help me on this!

bobk