convert byte data into varchar

Database

convert byte data into varchar

Hi,

It's possible to convert byte(35) data into varchar or something else?

Thanks,

Mica

3 REPLIES

Re: convert byte data into varchar

Hi Mica,

According to Teradata documentation you cannot convert byte data types to any other.
You can only convert byte to byte or blob.

Refer to SQL reference manual, functions and operators for details.

http://www.teradataforum.com/teradata_pdf/b035-1145-096a.pdf

Regards,

Cruz
Enthusiast

Re: convert byte data into varchar

You cannot directly convert byte or varbyte to any other type using Teradata SQL, but you could write a UDF that accepts arguments of one type and returns a value of some other type.

Re: convert byte data into varchar

Ok,

Thanks for your support.

Mica