jallende
Member
Hi list We have a problem with SQL in Oracle, I sorry by my unknow, but when I tried to run a SQL sentence with just a field like a DCTO in any file f.e. F4201, F4311 etc., grouped by this field and DCTO>= "9R", the result is first "SB", "SH" and then "9R", "9S" etc. Can anyone to explain me why Oracle order first characters an then numbers?
The sentence is:
SELECT CRPDTA.F4201.SHDCTO FROM CRPDTA.F4201 GROUP BY CRPDTA.F4201.SHDCTO
HAVING (((CRPDTA.F4201.SHDCTO)>="9R"))
ORDER BY CRPDTA.F4201.SHDCTO;
The result is:
SHDCTO
--------
SB
SH
9R
9S
9V
Any more information will be highly appreciated, thank a lot list.
javier
The sentence is:
SELECT CRPDTA.F4201.SHDCTO FROM CRPDTA.F4201 GROUP BY CRPDTA.F4201.SHDCTO
HAVING (((CRPDTA.F4201.SHDCTO)>="9R"))
ORDER BY CRPDTA.F4201.SHDCTO;
The result is:
SHDCTO
--------
SB
SH
9R
9S
9V
Any more information will be highly appreciated, thank a lot list.
javier