Need to strip data in a column using a Trigger- Please help!

• davidsalazar01

  SSCarpal Tunnel

  Points: 4072

  More actions

  March 8, 2005 at 10:59 pm

  #166319

  DBA's or Developers ,

  I'm trying to strip data from a column in a table using an UPDATE trigger.  I've already created the initial logic to populate the data into column2 from column1.  But I want to remove the full name (e.g. John Doe) and the parentheses (e.g. Data123).       

  EXAMPLE OF HOW IT LOOKS NOW:

  Column1                                                   Column2           

  John Doe (Data123)                                    John Doe (Data123)

  EXAMPLE OF HOW I WANT IT TO LOOK:

  Column1                                                   Column2           

  John Doe (Data123)                                    Data123

  Thanks!

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  March 9, 2005 at 1:43 am

  #546058

  Hi,

  Try this

  select column1, substring(columnn1,charindex(columnn1,'(')+1,charindex(columnn1,')') as Column2

  from tbl

  

   

   

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me

• davidsalazar01

  SSCarpal Tunnel

  Points: 4072

  More actions

  March 9, 2005 at 10:28 am

  #546192

  Helen,

  Thank you!   I used something similar to what you wrote and it worked.

  DECLARE @in nvarchar(250)

  SET @in = 'Baxter Lane (BLANE)'

  SELECT SUBSTRING(@In, CHARINDEX('(', @in) + 1, CHARINDEX(')', @in) - CHARINDEX('(', @in) - 1)

  David