Add a Character to the value of a column

Question

Navigation

#1 by (1 votes)

2

I would like to know if you can include a character set at the end of a column's data.

For example:

'Coluna 1- Quantidade
 |10000
 |20000
 |15000
 |20000

I want to extract a query where I can display this data with a character after the number that way.

'Coluna 1- Quantidade
 |10000 Tons
 |20000 Tons
 |15000 Tons
 |20000 Tons

Is it possible?

Thank you very much

sql sql-server

asked by anonymous 29.08.2017 / 21:19

1 answer

score 1 · Accepted Answer

1

Do concatenation by adding text:

SELECT CAST(quantidade AS NVARCHAR) + ' Tons' FROM tabela

29.08.2017 / 21:23