How would I extract the 7 and 8th characters from a 13 charater string?

I have a table and I need to build a query in the query designer to extract the 7th and 8th character from a 13 character string.

I know how to extract left and right but not this.

Thanks
PBLackAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
place this in one of the query column

mid([nameofField],7,2)

that should give you the 7th and 8th character
0
 
PBLackAuthor Commented:
It is guaranteed that the string will always be 13 characters long.
0
 
PBLackAuthor Commented:
PT1: Mid([RF_TRTID],8,2) figured it out
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
PBLackAuthor Commented:
I got it after some trial and error and it was 8th and 9th. You get the points!

Thanks
0
 
Rey Obrero (Capricorn1)Commented:
that is not correct, that will give you the 8th and 9th character
0
 
PBLackAuthor Commented:
@ capricorn1  Yeah I made a mistake in the question. It was the 8th and 9th that I was after. Sorry about that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.