Hi, I stored some values in a column as a VARCHAR FOR BIT DATA and would like to view the value of the column, not in HEX but in character format. Is their a way to do a select on the column to do this?

We use UDB version 7.2 on Windows NT 4.

Thanks.

You can try the cast function, but I am not 100% sure it will work, and I don't know for sure if it is supported in version 7.

select cast(column-name as char(10)) ...

Hi Marcus_A, I tried using the cast function to convert the data from a HEX format to a CHAR format and it didn't work. The weird thing that I found out is when I ran this SQL, SELECT CAST(XML_DATA_TXT AS CHAR(1)) FROM VAPXMT1, I get a warning message that my data is truncated but at the end of the warning message, I can see the value that was stored in CHAR format.

Would their be another way to display the VARCHAR FOR BIT DATA as the value that inserted?

Thanks.

I don't know, but I would keeping making the CHAR bigger and see if that helps avoid the truncation message.