Alphabetical order

Database
Fan

Alphabetical order

Hello,

Is there any function/Way to dispaly the Word in Alphabetical order?

For example i have word, Coke, result will look like Ceko

3 REPLIES
Enthusiast

Re: Alphabetical order

Hi SatyaY,

Can we more understnd on what you are trying to achieve , so would be able to help you ?

Fan

Re: Alphabetical order

I am getting a attribute from the source and need to convert them in Alphabetical order. Do we have any stirght function to convert word from Non-Alphabtical order to Alphabetical order.

Enthusiast

Re: Alphabetical order

Hi Satya

I dont think we have any pre built functions,we need to write a specific processing logic with the use of array data type

or you can loop split and capture each letter to a column in a table sort it and save it within another table

By splitting 

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/ARRA...