>>try to get each word in a separate column in the select and order via SQL order by
>>
>>
>>thomas
>
>Thomas,
>
>it's still a problem since its mixed alpha and digit. The digits should be sorted as numbers, the alphas as alphas after the digits.
>
>As you can see in the message to Tore its a bit of PAD[L|R] to sort it out, but I need the lenght beforehand.
>
>
>Agnes
You can easily trim away the numeric parts to get the character date.