Function: IsUpper

Description

Returns 1 if character is uppercase alphabetic, otherwise returns 0 (zero).

Syntax

IsUpper(character)

Arguments

character can be a constant, a character field, an expression that results in a string or a function that returns a string. If character is longer than a single character, IsUpper operates on only the first character.

Return value

This function returns a number: 1 if character is uppercase alphabetic, otherwise it returns 0 (zero).

Calculated field example

The IsUpper() function has no practical application in a calculated field expression.

Filter/Find example

Records with a Part_no field that have an uppercase alphabetic character in the third character position (75T versus 75t) can be selected or found using the expression: IsUpper(Substr(Part_no,3,1))=1