sql server 2008 - SQL parse string -

i have sql column in format:

http://myserver/lists/myform/dispform.aspx?id=6, rab12egh234 http://myserver/lists/myform/dispform.aspx?id=5, cbtrr2345 

i want

rab12egh234 cbtrr2345 

i used this:

select     substring([formname], charindex(',', ([formname]), 0), 20)  [mydb].[dbo].[formlist] 

however results like:

 , rab12egh234  , cbtrr2345 

i don't want space, don't want comma names. how edit query? thanks.

skip 2 characters, , use rtrim() remove trailing spaces:

rtrim(substring(formname, charindex(', ', formname, 0) + 2, 20))                                                ^^^^^^ 

example @ sql fiddle.