How to select records from a table on a certain number of specific letters in the record?

How to select records from a table in which, for example in the "Name" field just the two letters 'a' (or, for example, not more than 3)?
There is clearly clear that we need to use templates. But can't figure out how to specify a certain number of characters.
June 10th 19 at 15:18
1 answer
June 10th 19 at 15:20
I have so many documents to go over ...
This including. - Horace.Legros75 commented on June 10th 19 at 15:23
reread, everything is there - Mckayla.Scho commented on June 10th 19 at 15:26

Find more questions by tags Transact-SQL