How to select records from a table by a certain number of a particular letter in a record?

Question

Transact SQL

How to select records from a table, in which, for example, in the "Name" field, there are only two letters 'a' (or, for example, no more than 3)?
Here it is clearly clear that you need to use templates. But I can't figure out how to set a certain number of characters.

Answer 1

doka