How to select records based on 2 consecutive Letters in a field

G

GOPALAKRISHNAN

I have Inventory Table having one of the field as Product Code.
'Product code' field has 10 charectors whose 5th & 6th Charectors show
the type of the product.


How to select records having the 5th & 6th Charectors as G and A?
What is to be written in WHERE clause?
 
R

Rick Brandt

GOPALAKRISHNAN said:
I have Inventory Table having one of the field as Product Code.
'Product code' field has 10 charectors whose 5th & 6th Charectors show
the type of the product.


How to select records having the 5th & 6th Charectors as G and A?
What is to be written in WHERE clause?
Click to expand...

WHERE [Product Code] Like "????GA*"
 

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

*REPOST* Select Records based on 2 dates 11
Merge multiple records in a field, based on criteria? 2
How do I add data from a query to a subdatasheet? 1
How to count consecutive records base on 2 groupings 0
Can I list from 2 tables or qrys in 1 form? 5
How to use 2 separate qrys in 1 form? 1
need to find & save fields to 2nd table 1
How to select characters in a field? 2

Top