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?
 
Top