Conversion of ascii values to coresspondin alphabets.

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Conversion of ascii values to coresspondin...

Rate Topic

Display Mode

Topic Options

Author

Message

smilever

Posted 8/28/2008 3:06:53 AM

Forum Member

Group: Forum Members
Last Login: 10/15/2008 9:11:28 AM
Posts: 27, Visits: 77

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:-)

smilever

Post #12762

Adeel.Chaudhry

Posted 8/28/2008 3:10:22 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197, Visits: 611

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

Post #12763

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 10:19pm