> Herb 50 Payroll / Example: Wildcards in an expression

Herb 50 Payroll example: Wildcards in an expression

The following examples use a % symbol in the expression to indicate a wildcard, that can match any other text.

Wildcard	Description	Example
%	Use percent (%) as a substitute for multiple characters.	Employees whose tax code ends with the letter L: Employees.TaxCode LIKE "%L"
_	Use underscore (_) as a substitute for a single character.	Employees who have a tax code that begins with a K and is followed by three numbers: Employees.TaxCode LIKE "K___"

Wildcard

Description

Example

Use percent (%) as a substitute for multiple characters.

Employees whose tax code ends with the letter L:

Employees.TaxCode LIKE "%L"

Use underscore (_) as a substitute for a single character.

Employees who have a tax code that begins with a K and is followed by three numbers:

Employees.TaxCode LIKE "K___"