Posted by Sergey on 03/20/06 16:19

--something like this:
declare @tranid_position int, @amp_position int,@string varchar(8000),
@rest_of_string varchar(8000), @Result_string varchar(8000)
set
@string='Code=web.co.uk%product_free&TranID=14077576&OtherFlag0=services.web.stats.P­ostCSDelivery&OtherFlag0par=deliv
'
set @tranid_position=charindex('&TranID=',@string)
set @rest_of_string= substring(@string,@tranid_position+8,8000)
set @amp_position=charindex('&',@rest_of_string)
set @Result_string=left(@rest_of_string,@amp_position-1)
select @Result_string

• Next in forum: Re: Check constraint does not work (compare with null)
• Prev in forum: Re: SQL query - duplicate records - different dates - how to get only latest information?
• Thread view: Re: Help with a substring query

[Reply to this message]