Both the * and % can be used interchangeably for wildcard characters in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be enclosed in brackets ([]). If a bracket is in the clause, each bracket character should be enclosed in brackets (for example [[] or []]). A wildcard is allowed at the start and end of a pattern, or at the end of a pattern, or at the start of a pattern. For example:
ItemName LIKE '*product*'
ItemName LIKE '*product'
ItemName LIKE 'product*'
Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.
Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.