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

[Back to original message]