I need to count the number of records in a table where there are more than three alpha characters in a specific field.
So if there were two records :
Record 1 : Field=OT12/12BV
Record 2 : Field=OT12/12B
and I ran the query, the count would be 1 - as the first record has four alpha characters in the field and the second record has three alpha characters in the field.
I have searched for other questions like this but I guess it is an unusual one as I can't find anyone trying to do exactly this.
Note: the count is for characters A - Z - not special characters.
Any help would be appreciated.