how to format the column

jinsezh · #1 (**permalink**) 08-31-06, 12:25

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

n_i · #2 (**permalink**) 08-31-06, 19:17

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)"

Internet Services

Web Development

Digital Marketing

Consumer Tech