Script to append character?

• WaIIy

  Ten Centuries

  Points: 1327

  More actions

  July 11, 2007 at 12:13 pm

  #98482

  Hi All,

  I need to go through a set of records, and based on an ID match between a source table and the main table - add a 'X-' to the front of an employees name.

  Can anyone get me off to a good start here for the character addition?

  THX.

  RW

  [font="Verdana"]-- Wally
  -- Reluctant DBA[/font]

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  July 11, 2007 at 12:47 pm

  #718750

  UPDATE SourceTable

  SET EmployeeName = 'X-' + EmployeeName

  WHERE Sourcetable.ID = MainTable.ID

  
  
  Mark

• WaIIy

  Ten Centuries

  Points: 1327

  More actions

  July 11, 2007 at 2:11 pm

  #718780

  Perfect!

  Actually had just about figured it out.

  Thanks Mark.

  [font="Verdana"]-- Wally
  -- Reluctant DBA[/font]