select top 10 SUBSTRING( sproductcode, CHARINDEX('-', SProductCode)+1, LEN(SProductCode))
from csmrep.crmextdb.dbo.imei
select top 10 SUBSTRING( sproductcode, CHARINDEX('-', SProductCode)+1, LEN(SProductCode))
from csmrep.crmextdb.dbo.imei
转载于:https://www.cnblogs.com/fengwenit/p/4193428.html