[{"deliveryAct":"223","deliveryType":"特别","index":3,"name":"刘刘","workflowId":238},{"deliveryType":"预备","index":4,"name":"迁移","workflowId":141}]
大神们，有这样的一字段，想求取deliveryAct后的数字串，求解救，试了SUBSTR(a.newbanner,charindex("deliveryAct",a.newbanner)+12,5)这个公式，不行，charindex这个函数说是不能识别。