Puchase order No series sorting problem

vyanku

We had migrated database from 4.o SP2 native to 5.0 SP1 SQL option.
In Purchase order there are 3 no. series.
1. PO0001 to PO9999
2. 08PO00001 to 08PO99999
3. 09PO00001 to 09PO99999

In 4.0 database the Purchase order no are sorting as PO0001 first then 08PO00001 and then 09PO00001 last
But in 5.0 SP1 it shows 08PO00001 first then 09PO00001 then PO0001
sorting keys are same in 4.0 as will as in 5.0
why they are not sorting as they sorted in 4.0? ](*,)
Any budy please suggest

mohana_cse06

May be because of SQL option :-k

kine

Yes, it is because SQL have different sorting priorities than Native DB.

vyanku

Can we sort it as per 4.0 sorting?