--將ntext轉換成nvarchar(8000)試試看update T set [P]=substring(convert(nvarchar(8000),[W]),charindex('<IMG src="upload/',convert(nvarchar(8000),[W]),)+18,charindex('" border=0>',convert(nvarchar(8000),[W]),)-19)
declare @str varchar(8000),@result varchar(8000),@startpot int,@endpot int select @str=convert(varchar(8000),W) from T set @startpot=CHARINDEX('<IMG "src=upload/',@str)+17 set @endpot=CHARINDEX('" border=0>',@str) set @result=SUBSTRING(@str,@startpot,@endpot-@startpot) select @result
set [P]=substring(convert(nvarchar(8000),[W]),charindex('<IMG src="upload/',convert(nvarchar(8000),[W]),)+18,charindex('" border=0>',convert(nvarchar(8000),[W]),)-19)
select @str=convert(varchar(8000),W) from T
set @startpot=CHARINDEX('<IMG "src=upload/',@str)+17
set @endpot=CHARINDEX('" border=0>',@str)
set @result=SUBSTRING(@str,@startpot,@endpot-@startpot)
select @result
http://community.csdn.net/Expert/topic/4799/4799812.xml?temp=.5322687