pcsoft.us.windevCopyright 2026, PC SOFT3 Jan 2016 13:37:00 Z2 Jan 2016 17:04:00 ZHello All, I have a report that I want to sort on a Item "Lot Number" which is a alpha numeric. The current results of the sort are 1,10,2,22,23,3 ect is there any way to sort this 1,2,3,4 ect. Thanks, DW30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55719/read.awp3 Jan 2016 13:37:00 ZHello DW If you put the data into a memory table and report from the table you can use the extended sort functions of the tab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55719/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55719/read.awpNumeric/text sorting on a report WD19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55718/read.awp3 Jan 2016 12:49:00 ZHi DW, If you use MYSQL OR another DB than hyperfile, you can try CAST() function with ORDER BY . Best Regards/ Ab.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55718/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55718/read.awpNumeric/text sorting on a report WD19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55717/read.awp2 Jan 2016 17:23:00 ZHi DW Your current result is "correct" for alpha-numeric fields. To get what you want, you could a) change the item typ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55717/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55716-numeric-text-sorting-report-wd19-55717/read.awpNumeric/text sorting on a report WD19