truncate string

• mscs90

  SSC Journeyman

  Points: 89

  More actions

  April 22, 2011 at 8:11 pm

  #238463

  How do you truncate a string everything before/after a certain character, including the character? The number of characters on either the right or left side of the character varies.

  shfdiuf/lsdfsjfij truncate everything to the right or left of the / character

  return:

  shfdiuf truncate everything to the right

  lsdfsjfij truncate everything to the left

  shfdiuf%lsdfsjfij truncate everything to the right or left of the % character

  return:

  shfdiuf truncate everything to the right

  lsdfsjfij truncate everything to the left

• iDiPs

  Old Hand

  Points: 348

  More actions

  April 22, 2011 at 8:53 pm

  #1315080

  DECLARE @String VARCHAR(32) = N'shfdiuf/lsdfsjfij'

  SELECTLEFT(@String, CHARINDEX(N'/', @String) - 1),

  RIGHT(@String, CHARINDEX(N'/', @String) + 1)