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

[amir_saran]

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?

[Watermark]

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

[ncrlelia]

Hi @amir_saran,

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

Hope this helps.

Best Regards,

Lelia

[apathetichell]

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.