Truncate Statement

• joemai

  Hall of Fame

  Points: 3496

  More actions

  May 21, 2004 at 5:55 pm

  #108055

  Can someone please help. My data like this: Product MA7017A-T-TR-014 MA7017A-T-TR How can I write a sql statement that give the result like: Product                                                     Part MA7017A-T-TR-014                               MA7017A-T-014 MA7017A-T-TR                                       MA7017A-T Thanks very much. Minh

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  May 21, 2004 at 6:31 pm

  #507368

  Hi,

  Try these statements..

  SELECT Replace ('MA7017A-T-TR-014', '-TR', '') AS Part

  SELECT Replace ('MA7017A-T-TR', '-TR', '') AS Part

   

  
  Lucky