34,837
社区成员




with table1 as
(
select '钢管' goods, 'AA001' code union all
select '铅笔' goods, 'AB002' code union all
select '鼠标' goods, '6A001' code union all
select '键盘' goods, '70004' code
)
select * from table1 where code like '[0-9]%'
--select * from table1 where SUBSTRING(code,1,1)>'0' and SUBSTRING(code,1,1)<'9'