SQL Query Issue: Function to convert value of a single-select enumeration field to text

Question

I am able to successful connect to the database that contains my data and have run successful queries using that database but I keep getting an error when I try to use the SQL function to convert the enumeration value to text. The function that typically does this in other query editors is OP_RPS_AUX.CONVERT_EVIDLIST_TO_NAME

For example, here is a simple SQL query that has this issue:

SELECT NAME00

,CTRLGRP

,OP_RPS_AUX.CONVERT_EVIDLIST_TO_NAME (CTRLGRP)

FROM RT_CONTROL

This does not successfully run but if I get rid of the enumeration to text function, it runs easily. Is there anyone that could fix this for me please?

apathetichell · Answer

Can you confirm that your database that you are accessing data in is an IBM db? I do not believe that function is universal especially in contemporary SQL.

ncrlelia · Answer

Hi @amir_saran,

You can try CONVERT(VARCHAR(20), FORMAT(CTRLGRP, 'N')).

Hope this helps.

Best Regards,

Lelia

Watermark · Answer

Just convert it to text after you've pulled it into alteryx.