各位大侠,兄弟遇到一个大难题,请求各位大侠求急呀!
表中的一个字段<图号>(如:5F4.160.302) 要对它进行排序,要求是先对每二位起的后面部分进行排序后,再对第一位排充!
例:
排序前 排序后
5F4.160.302 2F0.123.008
2F0.123.008 2F0.123.1182
5F4.006.122 2F0.870.0008
2F4.111.1213 9F0.130.320
9F0.130.320 2F3.160.111
2F3.160.111 7F3.130.001
5L2.030.321 2F4.111.1212
2F4.111.1212 2F4.111.1213
2F0.870.0008 5F4.006.122
7F3.130.001 5F4.160.0003
2F0.123.1182 5F4.160.302
5H4.023.312 5F5.640.212
5L4.670.764 5H4.023.312
4I4.560.975 4I4.560.975
5F5.640.212 5L2.030.321
5F4.160.0003 5L4.670.764
怎么实现呀???小弟用的是ADOQuery,在SQL属性中,SELECT语句中的order by后面不知怎么写!!