All Forums Database
SatyaY 2 posts Joined 03/12
25 Sep 2015
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

gskaushik 56 posts Joined 09/10
26 Sep 2015

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

Regards
Subramanian kaushik Gurumoorthy

SatyaY 2 posts Joined 03/12
26 Sep 2015

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.

gskaushik 56 posts Joined 09/10
26 Sep 2015

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/ARRAY_Functions.081.008.html#ww14923132

 

Regards
Subramanian kaushik Gurumoorthy

You must sign in to leave a comment.