Adding a Character to a column value

Asked

Viewed 105 times

2

I would like to know whether it is possible to include a character set at the end of a column 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 this way.

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

It is possible?

Thank you very much

sql sql-server

1 answer

1


Concatenate by adding the text:

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

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.