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