比如现在有一个表
----------------------
col1 col2 .....
-----------------------
abc001
abc002
....
....
abc999怎样把 abc500到abc800的值查询出来???
----------------------
col1 col2 .....
-----------------------
abc001
abc002
....
....
abc999怎样把 abc500到abc800的值查询出来???
where col1 between 'abc500' and 'abc800'