Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

MS ACCESS string manipluation

I want to be able to parse a string and only return characters in position 4,5,6

example>

original string: 09-329-300-4701

resulting string: 329
0
solarisinfosys
Asked:
solarisinfosys
1 Solution
 
jerryb30Commented:
mid(yourfield,4,3)
0
 
solarisinfosysAuthor Commented:
Worked like a charm

Thank you so much
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now