Yes, it is true that the Specify 7 Query Builder supports % and _ wildcards when using the ‘Like’ operator, but not *. The same is true when searching with a query combo box field.
However, Simple Search does allow for the asterisk wildcard to be used!