--sqlserver 写法,不知道access 行不行 if exists(select * from sysobjects where name ='t') drop table t go create table t ( bid nvarchar(10) ) go insert into t select '10标段' union all select '2标段' union all select '3标段' union all select '4标段' union all select '5标段' union all select '6标段' union all select '7标段' union all select '8标段' union all select '9标段' union all select '1标段' go select * from t order by convert(int,substring(bid,0,PATINDEX('%[^0-9]%',bid)))
--sqlserver 写法,不知道access 行不行
if exists(select * from sysobjects where name ='t')
drop table t
go
create table t
(
bid nvarchar(10)
)
go
insert into t
select '10标段' union all
select '2标段' union all
select '3标段' union all
select '4标段' union all
select '5标段' union all
select '6标段' union all
select '7标段' union all
select '8标段' union all
select '9标段' union all
select '1标段'
go
select * from t order by convert(int,substring(bid,0,PATINDEX('%[^0-9]%',bid)))