Aug 11, 2007 #1 bobk5444 Programmer Jan 28, 2005 17 0 0 US 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
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
Aug 13, 2007 #2 mrmitchmitchell Programmer Jul 28, 2007 7 0 0 US when you write your query you can use the TRIM() function on that column Upvote 0 Downvote
Aug 13, 2007 Thread starter #3 bobk5444 Programmer Jan 28, 2005 17 0 0 US ok good idea thanks for the tip! have a great week and thanks for taking the time to help me on this! bobk Upvote 0 Downvote
ok good idea thanks for the tip! have a great week and thanks for taking the time to help me on this! bobk