In one of the projects we had the need to find all contacts whose last names contain spaces (if you must know, that’s because last names were used as a base for a subdomain). Trying obvious “Last Name Contains <space>” condition immediately gives you “Provide a valid value for Last Name”. Dynamics 365, just like the nature, abhors a vacuum.
Wildcards to the rescue – enter the condition as “Last Name Contains * *” and Dynamics 365 oblidges.
For example, let’s find all last names with not one but two spaces! “Last Name Contains * * *” should get you the results: