You can't use wildcards in statements like you want. The easiest way for you to do what you want is to just grant the user the db_datareader role and make sure they're not part of a group with the ...

SQL wildcard characters are used with the LIKE operator to search for data that matches a specific pattern in a column. Useful in flexible searches.