sql语句可以截取指定字段后面的字符串

select id,substring(Memo,charindex('数量',Memo)+3,len(Memo)-charindex('数量',Memo)) from trace where Memo like '%退货%'