Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Changing data in a table

Discussion in 'Information Technology' started by Chris, Nov 12, 2005.

  1. Chris

    Chris
    Expand Collapse
    Guest

    I am trying to figure out how to change the data in one field. I would like
    to remove a three letter prefix that accompanies my part number. There are a
    couple thousand entries so I am looking for the easiest way possible. Any
    Ideas??

    Thank you
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking about the big move: The Sikh way of life changing in Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes on a Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing my last name to Kaur... Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism and the Changing Electoral Demographic Breaking News Mar 8, 2013

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 11 Nov 2005 10:59:04 -0800, "Chris"
    <Chris@discussions.microsoft.com> wrote:

    >I am trying to figure out how to change the data in one field. I would like
    >to remove a three letter prefix that accompanies my part number. There are a
    >couple thousand entries so I am looking for the easiest way possible. Any
    >Ideas??
    >
    >Thank you


    An Update query would do the job. You don't say if you want to do this
    globally for all records, but if so: BACK UP YOUR DATABASE (just in
    case you make a mistake, or I do so in my advice), and run an Update
    query updating the field PartNo (use your own fieldname of course) to

    Mid([PartNo], 4)

    This function will return the substring of the field starting at the
    fourth byte and update the table to that substring; that is you'll go
    from

    ABD1234
    ADD1512
    XYZ3431

    to

    1234
    1512
    3431

    John W. Vinson[MVP]
     
  4. Chris

    Chris
    Expand Collapse
    Guest

    Thank a lot!
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page