Hello people,

I have made following query

this one works fine

Code:
SELECT DISTINCT
CAST (tt.OrderNr AS varchar(10)) + ' – ' + PostIt.Text AS 'Context Matches' 
FROM [Teknotrans_dev].dbo.OpusOrder as tt INNER JOIN
[MyDB].dbo.CompanyMain as c On tt.bolagsnr = c.id INNER JOIN
[MyDB].dbo.OpusOrderrow as ord On ord.ordernr = tt.ordernr INNER JOIN
[MyDB].dbo.PostIt as PostIt On PostIt.ordernr = tt.ordernr INNER JOIN
[MyDB].dbo.OrderCompanyName as snSrc ON ord.kallspraknr = snSrc.spraknr INNER JOIN
[MyDB].dbo.OrderCompanyName as snTrg ON ord.malspraknr = snTrg.spraknr
Now is my issue...

I want to include one column more to the cast seperated by "–"

columnname is:
tt.quationnr

the column contains two different values 0 or -1

could someone help me?

Thank you in advance