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

  • Thread starter Thread starter GOPALAKRISHNAN
  • Start date Start date
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?
 
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*"
 
Back
Top