where colname between substr('8-10万',1,instr('8-10万','-')-1)*10000 and substr(substr('8-10万',1,lengthb('8-10万')-2),instr('8-10万','-')+1)*10000;
string strsql="select * from Table "; switch(value) { case A: strsql+="where colname<80000"; break; case B: strsql+="where colname between 80000 and 100000"; break; case ……}
and substr(substr('8-10万',1,lengthb('8-10万')-2),instr('8-10万','-')+1)*10000;
switch(value)
{
case A:
strsql+="where colname<80000";
break;
case B:
strsql+="where colname between 80000 and 100000";
break;
case ……}