BETWEEN TEXT values with the '%' character

What happens if we insert a ‘%’ into a condition like so:

BETWEEN ‘D’ AND ‘F%’ ;

To a SELECT clause on a column whose values are supposed to be TEXT in a relation somewhere.

I’m curious, what all values does this operator compare from the column? Will it compare strings like ‘foot’ or ‘Fzzzzzzz’ to others in the column?

If you want to use a comparison with different bounds like this

BETWEEN ‘D’ AND ‘G’ ;

there is a possibility the single letter ‘G’ could be returned, if it is in the column. I would like if my query somehow did not return the single letter G. Practically, if G can somehow be flagged as anomalous and therefore not returned, I’m curious how that is done.