--楼上的还没有考虑输入的两个参数不是相同的情况,如'A20'--'C20',楼主可以试试下面的写法:select * from Table1 where substr(字段A,1,1) between substr('C1',1,1) and substr('C100',1,1) and to_number(substr(字段A,2)) between substr('C1',2) and substr('C100',2)
要求你这个C1的字段只带C这个字母,如果后面还有字母的话就不行了。 这个是已经测试过的。 Select to_number(substr(C1,2,length(C1))) From tablename Where to_number(substr(C1,2,length(C1)))>1 And to_number(substr(C1,2,length(C1)))<100
Select * From tablename Where to_number(substr(C1,2,length(C1)))>1 And to_number(substr(C1,2,length(C1)))<100
where
substr(字段A,1,1) between substr('C1',1,1) and substr('C100',1,1)
and
to_number(substr(字段A,2)) between substr('C1',2) and substr('C100',2)
这个是已经测试过的。
Select to_number(substr(C1,2,length(C1)))
From tablename
Where to_number(substr(C1,2,length(C1)))>1
And to_number(substr(C1,2,length(C1)))<100
From tablename
Where to_number(substr(C1,2,length(C1)))>1
And to_number(substr(C1,2,length(C1)))<100