SELECT
*,
SUBSTRING(a.n, iter.pos, 1) AS c
FROM (SELECT
'asdf1*h456' AS n)
a,
tb_num06 as iter
WHERE iter.startN<= LEN(a.n)
SUBSTRING 要进行截取的字符串,从第几个开始截取,截取多长
所以把表tb_num06 建成是系统表,创建2个字段,
第1个字段保存从第几个字符算起,
第2个字段保存截取多长