Truncate or something?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 13 digit numeric field of which I only want to pull the 7-10 digits.
The table is to big to export to excel and do a trunc right and left. How do
I do this?
 
Hi Dan,
Try MID(13_Digit_Field, 7, 4), it will give you digit from position 7 to 10.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating Results 10
Split data in field on character return 0
Make Table Query Truncating Memo Field at 255 Characters 2
Append truncates some text fields 4
Truncate data into another field 4
Truncating/ Eliminating few digits 0
Subquery - merge heading and subheading titles 0
The Epic Games Store's first big sale 0

Back
Top