Query on character field

[antopapa]

I would like to run a querie on Access, wherby if the field has a total lenght of 10 digits.
How could i view the query whereby it reads only digit place number 7 and 8.
I need to know what is the command for doing that kind of lookup.

Please let me know

Thanks already.

 

[erezmor]

hi there
if i got your point, you can use "Select field1,field2... From TableName where Mid(field1,7,2)=[whatever you're interested in]
this will check characters in position 7 and 8 (together)

hope it helps
Erez

 

[RivetHed]

check out the len() and mid() functions

len([fieldname])=10
mid([fieldname,7,2)

I think this is what your after if not post back

 

[RivetHed]

oops sorry erez, I was typing while you posted your reply