In my code, I'm trying to get get the result to be 0001.DESCRIPTION
Problem is I can't figure out how to properly concatenate.
Can someone help.
I currently have the following code:
SELECT RIGHT('0000' + CAST((glm.COMPANY) AS VARCHAR(4)),4) AS COMPANY,
WHEN glm.ACCT_UNIT = '15200' THEN (COMPANY) + glm.[DESCRIPTION])
END) "Report Group"
FROM LSPROD.dbo.GLNAMES glm
WHERE glm.ACCT_UNIT in ('15200') and COMPANY = 5