declare @location int
declare @temp nvarchar(100)
declare @temp1 nvarchar(100)
set @temp= N'周一001FL美通FL智星U31FL美服F30FL1.33FL4.75FL9.50'
set @location=charindex('FL',@temp)while @location>0
begin
set @temp1= SUBSTRING(@temp,0,@location) set @location=charindex('FL',@temp)
print @temp1
set @temp=substring(@temp,@location+2,len(@temp))
end
结果:
周一001
美通FL智
智星
美服F30
1.33F
4.75
9.50
怎么根据"FL" 提取出来
declare @temp nvarchar(100)
declare @temp1 nvarchar(100)
set @temp= N'周一001FL美通FL智星U31FL美服F30FL1.33FL4.75FL9.50'
set @location=charindex('FL',@temp)while @location>0
begin
set @temp1= SUBSTRING(@temp,0,@location) set @location=charindex('FL',@temp)
print @temp1
set @temp=substring(@temp,@location+2,len(@temp))
end
结果:
周一001
美通FL智
智星
美服F30
1.33F
4.75
9.50
怎么根据"FL" 提取出来
参考http://www.cnblogs.com/fengye2009/archive/2009/02/23/1396416.html
declare @location int
declare @temp nvarchar(100)
declare @temp1 nvarchar(100)
set @temp= N'周一001FL美通FL智星U31FL美服F30FL1.33FL4.75FL9.50'
set @location=charindex('FL',@temp)while @location>0
begin
set @temp1= SUBSTRING(@temp,0,@location)
print @temp1 set @temp=substring(@temp,@location+2,len(@temp))
set @location=charindex('FL',@temp)
if(charindex('FL',@temp)=0)
print @tempend