SELECT * FROM card02 WHERE
Len(ALLTRIM(meter_addr)) = Len(Chrtran(ALLTRIM(meter_addr),'0123456789',''))
AND meter_addr like '%'+xxx+'%'
INTO TABLE card03
这个运行结果是对的,然后我又加上中文,成了这个
SELECT * FROM card02 WHERE
Len(ALLTRIM(meter_addr)) = Len(Chrtran(ALLTRIM(meter_addr),'0123456789一二三四六七八九',''))
AND meter_addr like '%'+xxx+'%'
INTO TABLE card03
就有出错了,把没有数字的也筛选掉了,结果为空了