Extarcting string after and before a Character/Pattern

• SQLISLIFE

  SSC Enthusiast

  Points: 141

  More actions

  November 10, 2015 at 4:06 pm

  #302175

  Comments posted to this topic are about the item Extarcting string after and before a Character/Pattern

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  November 30, 2015 at 7:52 am

  #1842881

  More of an article than a script, but good basic knowledge. Thanks.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  January 6, 2017 at 5:15 am

  #1921082

  This was good the last time I looked at it. Still is.

• jluisi-857298

  SSC Rookie

  Points: 39

  More actions

  January 6, 2017 at 10:15 am

  #1921166

  ----select characters before / including /

  select SUBSTRING ('abcde/wxyz',0,CHARINDEX('/','abcde/wxyz')+1)

  I'm confused with the code above. Isn't the position of the first character of a string always = 1 ?

  I ran these queries:

  SELECT SUBSTRING ( 'abcde/wxyz', 0, 1 ) => returns nothing

  SELECT SUBSTRING ( 'abcde/wxyz', 1, 1 ) => returns 'a'

  Based on this, shouldn't the query be ?

  ----select characters before / including /

  select SUBSTRING ('abcde/wxyz', 1, CHARINDEX('/','abcde/wxyz'))

  Thank you