Forum Discussion
CARLOS_SFHD
Jun 22, 2023Copper Contributor
SORTING CELLS WITH NUMBERS, NUMBERS WITH DASHES, NUMBERS WITH TEXT
IM TRYING TO DO INVENTORY HERE AT WORK. HARLEY DAVIDSON SOME YEARS AGO CONVERTED THERE PART NUMBERING SYSTEM FOR ALL NEW PARTS FOR YEARS IT HAD BEEN, 5 DIGITS A DASH FOLLOWED BY 2 DIGITS (YEAR OF INT...
peiyezhu
Jun 23, 2023Bronze Contributor
Hi,
How about this way?
original data
门牌号
10A
100A
25A
result
门牌号
10A | |
25A | |
100A |
select * from 按门牌号自然排序 order by 门牌号 COLLATE NATURAL_CMP;
http://e.anyoupin.cn/EData/?p=Tools/detail&r=177