`

截取字段并转为ascii

阅读更多

select t.STAT_ID,
ASCII(substr(t.STAT_ID,1,1))||ASCII(substr(t.STAT_ID,2,1))||ASCII(substr(t.STAT_ID,3,1))||ASCII(substr(t.STAT_ID,4,1))

from XXX t
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics