Hi Friends,


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:


1. SELECT
2. COLUMN_ONE,
3. COLUMN_TWO AS NEW_USERNAME,
4. '<![CDATA[' + DECRYPT_CHAR(PASSWORD_COLUMN_NAME,'SOME_KEY') + ']]>' as NEW_PASSWORD
5. FROM
6. DBSCHEMA.TABLE
7. WHERE
8. COLUMN_ONE = 'SOME_VALUE'


Thanks in advance............

Try the below. The rest of the select statement stays the same!

'<![CDATA[' || DECRYPT_CHAR(PASSWORD_COLUMN_NAME,'SOME_KEY') || ']]>' as NEW_PASSWORD

HTH,

Regards,

Praveen