Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    33

    Question Unanswered: how to format the column

    Hello,

    I wonder if there is any command to format columns in SQL output, similar as "col ColumnName format a15" in Oracle, so that a nchar(200) column can only take 15 chars space in the output.

    Thanks a lot

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by jinsezh
    Hello,

    I wonder if there is any command to format columns in SQL output, similar as "col ColumnName format a15" in Oracle, so that a nchar(200) column can only take 15 chars space in the output.

    Thanks a lot
    It's not similar to Oracle's "format", but try "substr(ColumnName,1,15)"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •