表中字段:code 字符串,
现有数据 P20070500001 到P20070500100
查询条件:起始编号和结束编号
如果用 500001 到 500050,进行查询出 P20070500001 到 P20070500050 所有编号的数据,查询语句如何写?
------解决方案--------------------
select * from [Table] where right(code,6) between '500001 ' and '500050 '
------解决方案--------------------
select * from 表 where right(code,6) between '500001 ' and '500050 '
------解决方案--------------------
select * from tb where right(code,6) between '500001 ' and '500050 '