Post reply

Flat file with integer column right-align, It''s possible?

  • March 28, 2006 at 1:09 am

    #167538

    I want to export "Mytable" to a flatfile with export wizard, but my flatfile have all records of integer columns left-align instead  I want records of integer columns right-align.

    If I execute "select * from mytable" from osql I see records of integer columns right-align. Why?

    Any help will be appreciated.

    Thanks

  • March 28, 2006 at 1:55 am

    #629096

    I guess you can simply "pad out" those columns. Something like this...

    SELECT id, STR(id, 12) AS IdRightAligned FROM SYSOBJECTS

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

  • March 28, 2006 at 6:24 am

    #629125

    Thanks, but I can't use STR with "export wizard".

     

  • March 28, 2006 at 6:39 am

    #629132

    Oh.

    Can't you even create a view which uses STR, and export that?

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply