Posted by esther s via SQLMonster.com on 07/19/05 07:28

there are one table with a column with 16 varchar, eg. ________1245678( _
stands for space.).the database size is 15 MB.

when using bcp,

right-aligned data will be display.

Can i change it to left-aligned, eg. 12345678________?

i have use the store procedure with "ltrim" to cut off the spacing, Can i use
another methods to change it??

Thx

• Next in forum: duplicate rows but no key on the tables
• Prev in forum: Re: Using stored procedure result set in another stored procedure
• Thread view: problem about right aligned data when using bcp

[Reply to this message]