Modify Data to Add a Letter Before Numbers

• uknites

  SSC Veteran

  Points: 255

  More actions

  February 6, 2020 at 1:07 pm

  Go to Answer

  #3723570

  Hi

  I am using access and i have customers data (15k) records

  Now i want to modify a column 'Customers' in a table called 'MRF'

  In customers column i have ID Numbers of Customers

  I want to run a query to add a letter "X" before all ID numbers

  How can i do it

  thanks

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  February 6, 2020 at 1:13 pm

  Answer

  #3723574

  this should be simple -

  update MRF set Customer='x'+customer

   

  MVDBA

• Johan Bijnens

  SSC Guru

  Points: 135442

  More actions

  February 6, 2020 at 1:30 pm

  #3723580

  

  Before you do that. What is your goal ?

   

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• uknites

  SSC Veteran

  Points: 255

  More actions

  February 6, 2020 at 7:57 pm

  #3723730

  I was trying to copy the data from one column to another and then add X in front of it

  Thanks a lot

  I managed to do it with your help

  appreciated

• Jeff Moden

  SSC Guru

  Points: 1004546

  More actions

  Follow

  February 7, 2020 at 7:11 pm

  #3724036

  uknites wrote:

  I was trying to copy the data from one column to another and then add X in front of it

  Thanks a lot

  I managed to do it with your help

  appreciated

   

  The question is "WHY"?  Why is it necessary to prepend the data in the column with an "X"?  We ask these types of questions because people will sometimes have a method in their head to do something and end up doing things like you've requested when there might actually be a better way to accomplish the real "end goal" of the action.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)