CHAR_LENGTH & LENGHT

Char_length: Returns the length, in number of characters, of a specified string.

Syntax: CHAR_LENGTH(expr)

Syntax description

expr is any expression that evaluates to a character string.

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

Example: CHAR_LENGTH ("Time"."Month Name")

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

Length: Returns the length, in number of characters, of a specified string. The length is returned excluding any trailing blank characters.

Syntax: lenght(expr)

Syntax description

expr is any expression that evaluates to a character

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

Example: Length("Time"."Month Name")