Appending to a query result

[Dave Stolie]

Is it possible to append text to a column result within the query itself? The way our system is, I need it to return the result wrapped in the CDATA tag. The below doesn't work, but should illustrate the idea on line 4:

SELECT 
   COLUMN_ONE, 
   COLUMN_TWO AS NEW_USERNAME, 
   '<![CDATA[' + DECRYPT_CHAR(PASSWORD_COLUMN_NAME,'SOME_KEY') + ']]>' as NEW_PASSWORD
FROM 
   DBSCHEMA.TABLE
WHERE 
   COLUMN_ONE = 'SOME_VALUE'

[Jeanne Boyarsky]

Does it work if you use "||" instead of "+" ? I've used the two pipes as a concatenation operator in the past in Oracle. I've never tried plus.

[Dave Stolie]

It does, thanks!!

You guys who take your time to help out others are awesome It is appreciated.