Left and Right

Left: Returns a specified number of characters from the left of a string.

Syntax: Left(expr, integer)

Syntax description

expr is any expression that evaluates to a character string

integer is any positive integer that represents the number

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on String folder and select Left

Example: Left("Date (Common)"."Month Name",2)

===========================================================

Right: Returns a specified number of characters from the right of a string.

Syntax: Right(expr, integer)

Syntax description

expr is any expression that evaluates to a character string.

integer is any positive integer that represents the number of characters from the right of the string to return.

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on String folder and select Right

Example: Right("Date (Common)"."Month Name",2)