Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    6

    Unanswered: Need to remove 2 characters in a query as well as add 2

    I have a query where the result for a part number begins with "TD" so for example a part might be TD123456 or TD3686B1 or TD5A02.
    How can I remove the TD from the part# in my query.

    Also if I want to add 2 characters to the end of the part# how would that be done?
    Thanks appreciate the help
    Tom

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    For the first, look at the Mid() function. For the second, concatenate:

    Mid(...) & "AB"
    Paul

  3. #3
    Join Date
    Nov 2011
    Posts
    6

    Thanks Paul

    Worked perfect

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help, and welcome to the site by the way!
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •