Get certain character in a column

• rockzcm

  SSC Enthusiast

  Points: 174

  More actions

  March 4, 2008 at 9:21 pm

  #182970

  Hi

  I have got a column having data like

  RT 12.5R20 (P) OL

  RT 12.5R244(SP)GRADER

  I want only need the value before '('. So, the result will be RT 12.5R20 and RT 12.5R244

  Since the length of the character will change. Is there any funtions in T-SQL that I can use to achieve this?

  Thanks

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  March 4, 2008 at 9:39 pm

  #785300

  LEFT('RT 12.5R20 (P) OL', CHARINDEX('(','RT 12.5R20 (P) OL')-1)

  ---

  
  My blog: http://jahaines.blogspot.com

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  March 4, 2008 at 9:40 pm

  #785301

  Replace the text with your column name and all should be well.

  ---

  
  My blog: http://jahaines.blogspot.com