Conversion of ascii values to coresspondin alphabets.

Database
Enthusiast

Conversion of ascii values to coresspondin alphabets.

Hi All,

Is there any function in teradata sql to convert numeric values to coressponding alphabets.
For Eg;i have value 97.i need a function to convert it to 'a'

Thanks in Advance

Cheers:-)
1 REPLY
Teradata Employee

Re: Conversion of ascii values to coresspondin alphabets.

Hello,

There is no built-in function for ASCII conversion though, a UDF or SQL (search the forum I posted similar few days back) can be written for this purpose.

Regards,

Adeel