Declare @S Varchar(50) Set @S='152.0MM*99.0MM' Select Left(@S,CharIndex('m',@S)-1),SubString(@S,CharIndex('*',@S)+1,CharIndex('m',@S,CharIndex('m',@S)+2)-CharIndex('*',@S)-1)
或者麻烦点的: Declare @S Varchar(50) Set @S='152.0MM*99.0MM' select left(@s,charindex('*',@s)-3),replace(replace(reverse(left(reverse(@s),charindex('*',reverse(@s))-1)),'MM',''),'mm','')
简单: select substring(c,1,charindex('*',c)-1) as c1,substring(c,charindex('*',[c])+1,len(c)) as c2 from tablename 其中c是该列的列名,tablename是你的表名。
select substring(c,1,charindex('*',c)-1) as c1,substring(c,charindex('*',[c])+1,len(c)-charindex('*',[c])) as c2 from tablename
insert into Newtablename(fieldsname1,fieldsname2) select left(fieldsname,charindex('*',fieldsname)-1) fieldsname1, substring(fieldsname,charindex('*',fieldsname)+1,len(fieldsname)) fieldsname2 from tablename
Declare @S Varchar(50)
Set @S='152.0MM*99.0MM'
Select Left(@S,CharIndex('m',@S)-1),SubString(@S,CharIndex('*',@S)+1,CharIndex('m',@S,CharIndex('m',@S)+2)-CharIndex('*',@S)-1)
Declare @S Varchar(50)
Set @S='152.0MM*99.0MM'
select left(@s,charindex('*',@s)-3),replace(replace(reverse(left(reverse(@s),charindex('*',reverse(@s))-1)),'MM',''),'mm','')
select substring(c,1,charindex('*',c)-1) as c1,substring(c,charindex('*',[c])+1,len(c)) as c2 from tablename
其中c是该列的列名,tablename是你的表名。
insert into Newtablename(fieldsname1,fieldsname2)
select
left(fieldsname,charindex('*',fieldsname)-1) fieldsname1,
substring(fieldsname,charindex('*',fieldsname)+1,len(fieldsname)) fieldsname2
from tablename