I am trying to sort a column defined as char length of 10.
Values are right adjusted. Example:
' 050120'
' 050149'
' 050250'
' 060100'
' 050149R'
I would like the values 050149 & 050149R sorted together, instead of having the 050149R show up at the end. I saw a similar post but haven't been able to accomplish the task. Would appreciate any help.

How would you like to see sorted table ?

For the example given, this would be the sorted results:
' 050120'
' 050149'
' 050149R'
' 050250'
' 060100'

For example:

Lenny

I just tried that LEFT scalar function and the values with an Alpha on the end are still grouped at the end of the sort. It must be because the values that have a trailing alpha begin in position 4 of the field and those that don't have the alpha character begin in position 5 of the field.

So, you can try:

Lenny

String comparison goes throw 2 strings character-by-character and if the character in the first string comes before the corresponding character in the other string, the first string is lexicographically sorted before the other string. In your case, you reach the point where a space is compared with '0', which leads to all strings with a space in that position to be sorted before all strings with a '0'. What you have to do is get rid of the leading spaces. A function like LTRIM() may be what you need, e.g. ORDER BY LTRIM(myCol).

Oh, I did not see space in position1:

or

Lenny

@Lenny77:

The values are right adjusted. There are different number of preceeding blancs. Therefore SUBSTR() or LEFT() don't work.

As stolze mentioned, LTRIM() [ ... or STRIP() ] is the solution

Thanks one and all for the valuable assistance.
It sorts perfectly by using
ORDER By
LTRIM(Charcol)

Oh, boy !
You are right. I did not read about right adjusting !

Lenny

Bad formatting in the original post, I guess. Without right-adjustment, you don't need to do anything - just sort the left-adjusted values and that's it.