Updating a field

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  January 5, 2009 at 1:49 pm

  #198052

  How can I update a field that table contains about 800 records and field1 contains the same number of letters but different data and each column ending with letter "P" and size is 5 letters. I need to update everything in the field that = to P to B

  Example J0204P = J0204B

  Thank you

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 5, 2009 at 2:31 pm

  #921440

  Something like this will work:

  Update table

  set column = Left(column, 5) + 'B'

  Where

  right(column, 1) = 'P'

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question