Using ArcGIS 10.2.2, I have a string field in an SDE attribute table. I need help creating a query to select all records that have a zero in the 6th and 7th character of the field (i.e 1995-0023A). To help me better understand this type of query, I would also like to be able to see a query that selects records with a zero in just the 6th character of the field. I can then use the "and" clause and duplicate it to select the 7th character as well.
I've tried variations of
"FIELD1" LIKE '%00_______' but it doesn't select records with the double zeroes in the correct place in the string.