先写个函数提取a*b里的a,b到两个real类型里。然后再排序吧。 function AbtractAB(s:string;var a,b:integer); var len,Star:integer; TmpA,TmpB:string; begin len:=length(s); Star:=pos(s,'*'); TmpA:=copy(s,0,star); TmpB:=copy(s,star+1,len-Star-1);////////可能有些不精确,自已调一下。 a:=StrToInt(TmpA); b:=StrToInt(TmpB); end;select * from table1 order by a order by b
oracle: select substr('123456*123',instr('123456*123','*')+1) from dual;
select substr(尺寸,ChrIndex('*',尺寸),datalength(尺寸)) as 高度 from yourtable order by 高度
function AbtractAB(s:string;var a,b:integer);
var
len,Star:integer;
TmpA,TmpB:string;
begin
len:=length(s);
Star:=pos(s,'*');
TmpA:=copy(s,0,star);
TmpB:=copy(s,star+1,len-Star-1);////////可能有些不精确,自已调一下。
a:=StrToInt(TmpA);
b:=StrToInt(TmpB);
end;select * from table1 order by a order by b
select substr('123456*123',instr('123456*123','*')+1) from dual;
from yourtable order by 高度