Select, Count, Where (Like) HELP!

[nols76]

Hello all,
Having a tough time figuguring this one out. I have thousands of primary key reference numbers in a table such as:



2011015003001140
2011015003001150
2011015003003480
2011055065006480
2011065065006480
2011065065006490

I tried to run a query that counts the records that have a '65' in the 9th and 10th digits ONLY. No luck with the below. Can someone please help?

 
SELECT Count([Messages Sent].[Reference Number]) AS [CountOfReference Number]
FROM [Messages Sent]
WHERE ((([Messages Sent].[Reference Number]) Like "????????65??????"));

[pbaldy]

I would probably use the Mid() function, like:

WHERE Mid(...) = 65

More info on the Mid() function in Help.

[nols76]

many thanks

[pbaldy]

No problem, and welcome to the site by the way.