llcong 发表于 2016-11-14 06:40:48

DB2 substr posstr

select substr(column,posstr(column,'cc'),10)
from table

posstr(column,'cc'):相当于java indexOf
substr:截取函数
页: [1]
查看完整版本: DB2 substr posstr