Sort characters in a string
I have a varchar(10) field in a table. I would like to sort the characters within a given string, in this field, in ascending order, using a SQL query.
i.e. If the field has "airlines" ... I would like to have "aeiilnrs" as the result (from my SQL query).
How can I do this?
Thank you for your time.
Sorting homework problem? Impress your teacher by using bubble sort and PL/SQL collections.
Bubble sort algorithm:
Click Here to Expand Forum to Full Width