CharIndex Manipulation (SQL 2012). Select Case Statement to remove Part of String after one or two specific characters.

• tindog

  SSCarpal Tunnel

  Points: 4892

  More actions

  June 4, 2015 at 4:59 am

  #1802939

  Far from elegant, but this may work

  SELECT RTRIM(CASE WHEN CHARINDEX(',',Address) < CHARINDEX('*',Address)

  THEN SUBSTRING(Address,0, CHARINDEX(',',Address))

  WHEN CHARINDEX(',',Address) > CHARINDEX('*',Address)

  THEN SUBSTRING(Address,0, CHARINDEX('*',Address))

  ELSE Address

  END)

  LinkedIn