dibs dibley,
The answer given in the prior response is correct for most SQL syntax. Some implementations of the LIKE predicate (that's what the father of relational theory calls them. Just remember from high school English, when diagramming a sentence? The predicate is the 'action' taken upon the subject. And that's what most documentation calls that part of an SQL statement, the predicate) use a different 'wild-card' character.'
I've seen some use the asterisk '*', it's not an asterick, Rick wouldn't like that. Just remember from the famous speach, "I regret that i have one as-te-risk for my country". sorry for the digression, but that helps me to remember the correct pronunciation.
Some SQL implementations use one or the other, but rarely both.
If you find that the "%"- which means any character AND any number of characters in this position, returns no rows, then try the "*" in its exact place.
Keep in mind that this is not an "=" predicate, but a LIKE predicate, they are not interchangeable when looking for "patterns". The "=" predicate, of course, will check for an exact (not a
pattern) match.
FYI, there are 7 predicate types in SQL, these are two of them
Best of luck and hope this expands your understanding of fundamentals of the power of SQL.
REgards,
Gary Joehlin
Colorado Springs, CO