I've got the following code snippet, and I would like to add a dash in order to separate the two values. Every method I've tried has failed, and I was hoping someone might be able to assist me with this issue. The code snippet is:
when a.[CSGSYS] = 8495 THEN CAST(CONCAT(a.[CSGSYS], a.[CSGPRIN]) AS INT)
end as 'SYS_PRIN'
Any assistance anyone can give me is greatly appreciated. Thank you.