Function: IsAlpha

Description

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

Syntax

IsAlpha(character)

Arguments

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

Return value

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

Calculated field example

If the Part_no field begins with an alphabetic character, the following calculated field expression would return the field value, otherwise the expression will return a blank value. This expression might be used to return only part numbers that begin with an alphabetic character code. If(IsAlpha(Part_no)=1,Part_no,"")

Filter/Find example

Records with a Part_no field beginning with an alphabetic character can be selected or found using the expression: IsAlpha(Part_no)=1