Punctuation are characters that are not numbers or letters. If the number of product IDs is large, use a lookup instead of a wildcard.ДЄvoid using wildcards to match punctuation.ProductID='SC-MG-G01' OR productID='SF-BVS-G01' If the number of product IDs is small, specify the exact product IDs in your search rather than using a wildcard.To learn more about how punctuation can impact using wildcards, see Event segmentation and searching. Because there are no segments that match your search, no results are found.ДЄ search that uses a wildcard in the middle of the term returns inconsistent results because of the way in which data that contains punctuation is indexed and searched. There is no segment that starts with an S and ends with G01 which is what the search productID='S*G01' specifies. For example, the product ID SC-MG-G01 has these segments: SC, MG, G01. When the events with the product IDs are indexed, the product IDs are broken up into segments. You create a search that looks for all of the product IDs that begin with the letter S and end in G01. This is especially true if the string contains punctuation, such as an underscore _ or dash - character.ДЇor example, suppose you have the following list of product IDs. Wildcard characters in the middle of a word or string might cause inconsistent results. There are several situations in which you should avoid using wildcard characters.ДЄvoid using wildcards in the middle of a string Specify a field-value pair whenever possible to avoid searching the raw field, which is the entire event. The best way to use a wildcard is at the end of a term, such as 'fail*'. For example, searching for 'access denied' is always better than searching for 'access*'. Searching for a specific word or phrase is more efficient than a search that uses a wildcard. Sometimes that means not using a wildcard. The more specific your search terms are, the more efficient your search is. To avoid these problems, be as specific as you in your search criteria. Additionally, you might wait a long time for your search results. You'll use a lot of system resources, which can prevent others from running their searches. A search to match everything is both inefficient and time consuming. All events are retrieved, up to the maximum limit. If you specify an asterisk with no other criteria, you are asking to match everything.

See the section Other supported wildcards later in this topic.

The LIKE function supports using other wildcards for pattern matching. When you use a wildcard character, the string must be enclosed in quotation marks. You can use the asterisk ( * ) character as a wildcard to match an unlimited number of characters in a string.

Pdf search wildcard