Wild Cards * and ? may be used - what does this mean?

[Chris Hadden]

Under advanced search it says " Wild Cards * and ? may be used" How are those used? what does it mean?

Thanks
Chris

[david-ebt]

The * means match one or more characters and the ? means match 1 character.

Take a look at this web page http://www.techonthenet.com/sql/like.php. The % is the same as the * and the _ is the same as the ?. * and ? are standard in regular expressions but SQL uses % and _.

Hope that helps!

[Logan Rhodehamel]

If you are doing a search you can use the * character to match any characters. So like when searching users a search of "*@domain.xyz" in the email field would show you all users with some email at the given domain.

Just as an FYI, in the future we are going to move away from supporting the ? wildcard character.

[Chris Hadden]

Ok thanks, I must say that truly is..... "advanced"... as no customer of mine would ever have the foggiest idea what those search functions are, just serves to confuse them.