truncating unwanted characters.

• Ann Compton

  Newbie

  Points: 3

  More actions

  August 22, 2005 at 10:39 am

  #66798

  I am running SQL 2000 sp3 on Server 2000.  I am moving data from a legacy application into SQL through DTA.  I want to truncate characters from a comment field.  The characters do not always occur in the same position.  Is there a way this can be done?  For example ********RA#12345*****.  I need to remove the character "*".

  Thanks.

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  August 22, 2005 at 10:54 am

  #583977

  use replace, look it up in bol