getting name value from a string using TSQL

Question

I just edited the question to make it more clear.. please help

I am using SQL server 2008.

I have a column containing the following strings..

http://www.microsoft.com?abc=1234&def=567&ghi=891
http://www.microsoft.com?abc=4587&def=567&ghi=891
http://www.microsoft.com?abc=2478&def=567&ghi=891
http://www.microsoft.com?abc=9874&def=567&ghi=891
http://www.microsoft.com?abc=5412&def=567&ghi=891

In the following string, how can I get values of "abc" using TSQL?

the result should be ...

Please let me know.

thanks

Are you reading this from a table or trying to parse some input? Also do you expect the position of abc to change or is it expected to be a static bit of data? — JonVD
– JonVD, Commented Nov 8, 2010 at 22:48
Are you only looking for the first parameter, or all parameters in the URL string? — MattB
– MattB, Commented Nov 8, 2010 at 22:49

Joe Stefanelli · Accepted Answer · 2010-11-08 22:56:04Z

3

declare @x varchar(100)
set @x = 'http://www.microsoft.com?abc=1234&def=567&ghi=891'

declare @param varchar(100)

set @param = 'abc='
select SUBSTRING(@x, charindex(@param, @x)+LEN(@param), CHARINDEX('&', @x+'&', charindex(@param, @x)) - CHARINDEX(@param, @x)-LEN(@param)) as abc

set @param = 'def='
select SUBSTRING(@x, charindex(@param, @x)+LEN(@param), CHARINDEX('&', @x+'&', charindex(@param, @x)) - CHARINDEX(@param, @x)-LEN(@param)) as def

set @param = 'ghi='
select SUBSTRING(@x, charindex(@param, @x)+LEN(@param), CHARINDEX('&', @x+'&', charindex(@param, @x)) - CHARINDEX(@param, @x)-LEN(@param)) as ghi

edited Nov 8, 2010 at 22:56

answered Nov 8, 2010 at 22:49

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

serhat_pehlivanoglu · Accepted Answer · 2010-11-08 22:51:24Z

0

you can use the substring method on t-sql, but you would have to know the start and length parameters. i mean if the string value changes, it won't work.

answered Nov 8, 2010 at 22:51

serhat_pehlivanoglu

9828 silver badges14 bronze badges

Collectives™ on Stack Overflow

getting name value from a string using TSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related