select *,
SValue1=case when(isnull(展开尺寸,'') <> '') then left(展开尺寸,charindex('*',展开尺寸)-1)else '' end,
SValue2=case when(isnull(展开尺寸,'') <> '') then substring(展开尺寸,charindex('*',展开尺寸)+1,50)else '' end
from t_rpart
select *,
SValue1=case when(isnull(展开尺寸,'') <> '') then left(展开尺寸,charindex('*',展开尺寸)-1)else '' end,
SValue2=case when(isnull(展开尺寸,'') <> '') then substring(展开尺寸,charindex('*',展开尺寸)+1,50)else '' end
from t_rpart