Parse string from URL between...

• Jason A. Long

  SSC-Insane

  Points: 23786

  More actions

  December 15, 2015 at 5:03 pm

  #1846227

  This simply keys off of the 1st not integer character following the start of the numeric sequence...

  It could also be easily converted into a very efficient iTVF...

  DECLARE @url VARCHAR(8000) = 'http://www.mydomain.info/Customer.aspx?h_hmid=2907831&dcc=EUR&mobiredirect=no&cpn=3790';

  SELECT

  LEFT(

  SUBSTRING(

  @url,

  CHARINDEX('hmid=', @url) + 5, 8000),

  PATINDEX('%[^0-9]%',

  SUBSTRING(

  @url,

  CHARINDEX('hmid=', @url) + 5, 8000)

  ) -1

  )

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  December 16, 2015 at 1:27 am

  #1846251

  To add a bit more fun, what if

  DECLARE @url VARCHAR(8000) = 'http://www.mydomain.info/Customer.aspx?xxh_hmid=45678&h_hmid=2907831&dcc=EUR&mobiredirect=no&cpn=3790';