SQL - Aligning Column Values to Right

0

Hello

I would like to know if by means of a SQL statement there is some possibility of aligning the column values to the right. Here's an example below that I can do via C #, but I wanted to do the alignment only via T-SQL:

C # code that works:

result = string.Format("{0,16}{1,8}{2,4}{3,6}{4,15}{5,15}{6,16}",
                       reader["Coluna1"].ToString(),
                       reader["Coluna2"].ToString(),
                       reader["Coluna3"].ToString(),
                       reader["Coluna4"].ToString(),
                       reader["Coluna5"].ToString(),
                       reader["Coluna6"].ToString(),
                       reader["Coluna7"].ToString());

Result of the variable "result": 211582060520130004059: 30 0.00 0.00 0.00N

    
asked by anonymous 07.08.2018 / 21:35

0 answers