Please give me answer for "How to Search(box) list of contacts using wildcard characters(*,%,?) in salesforce "

  • 2
    Are you asking how to do wildcard searches in the Global Search? If so, none of the tags you've specified apply to the question. Jan 22, 2014 at 16:19

2 Answers 2


If you are asking in standard salesforce functionality here is the answer : 1. * (Asterisks) match zero or more characters at the middle or end (not the beginning) of your search term. For example, a search for john* finds items that start with john, such as, john, johnson, or johnny. A search for mi* meyers finds items with mike meyers or michael meyers. If you're using sidebar search, an * is automatically appended to the end of the search string. You can use an * at the beginning of a search term in a standard lookup search.

2.? (question mark) Question marks match only one character in the middle or end (not the beginning) of your search term. For example, a search for jo?n finds items with the term john or joan but not jon or johan. If you're using global search, the ? is removed from the end of your search term and isn't treated as a wildcard. You can't use a ? in a lookup search.


Wildcards take on the type of the preceding character. For example, aa*a matches aaaa and aabcda, but not aa2a or aa.!//a, and p?n matches pin and pan, but not p1n or p!n. Likewise, 1?3 matches 123 and 143, but not 1a3 or 1b3. You can't search for a ? or * in a search phrase that is enclosed in quotation marks or when Exact phrase is selected in the search scope because they function as wildcards. For example, "my wo?d" matches my wood and my word. A wildcard (*) is appended at the end of single characters in Chinese, Japanese, Korean, and Thai (CJKT) searches, except in exact phrase searches. If you're entering search terms in global search, the search box drop-down list gives you the option to search for your term with an * added to the end. For example, type jo in the search box, then select Search for jo* (starts with) to find joan, john, johnson, and other matches that start with jo.


The documentation that Salesforce provides is very good, take a look.


  • 3
    Yep, Salesforce documentation is a really good read... As is the Google: google.com/search?q=salesforce+search+contact+wildcards What fascinates me is that increasingly more and more people are LAZY to google for pretty basic Q&As, documentation of basic functionalities etc. Maybe I'm just too cranky today, but I guess the questions should reflect minimum of own effort put into the resolution of the problem. PS. @Michael Welburn - not aimed at you, but at the original poster
    – dino ursic
    Jan 22, 2014 at 16:35
  • Hi @Michael! I'm unable to find the documentation at the link you provided. It seems the document ids taken off by salesforce. Can you help me if you have a copy of the same with you. Or if you are aware of the new link. I was unable to find it in SFDC documentation library. Feb 8, 2016 at 11:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .