Removing Characters

• bpowers

  SSCertifiable

  Points: 5483

  More actions

  March 30, 2009 at 8:15 am

  #129002

  I am trying to come up with a way to remove anything after a 'space' from our Part ID's. Using the example below, I want to remove 'REP' and 'OVR'. Any ideas on how I can accomplish this?

  1134200-7 REP

  5-AS350-19 OVR

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 30, 2009 at 8:27 am

  #968382

  Assuming there's only one occurance of a white space you can use something like this:

  SELECT LEFT(Part_ID, CHARINDEX(CHAR(32), Part_ID))

  [font="Verdana"]Markus Bohse[/font]