A aerobull Unregistered / Unconfirmed GUEST, unregistred user! 2001-05-17 #2 select * from aa where 电话号码 like '210%' or 电话号码 like '228%' or 电话号码 like '410%'
楚 楚非帆 Unregistered / Unconfirmed GUEST, unregistred user! 2001-05-18 #3 来晚了！：） dabaosod说的没错，like语句是进行模糊查询
小 小芮 Unregistered / Unconfirmed GUEST, unregistred user! 2001-05-18 #5 to aerobull:那样效率不高，在sysbase中可以用 select * from aa where substring(电话号码,0,4) in('210','228') 具体语法忘了。。。。。。
to aerobull:那样效率不高，在sysbase中可以用 select * from aa where substring(电话号码,0,4) in('210','228') 具体语法忘了。。。。。。
H HORNEY Unregistered / Unconfirmed GUEST, unregistred user! 2001-05-18 #6 select * from table where number in ("210%","228%","410%")
