BuiltIn Functions › $ALPHABETIC Function

$ALPHABETIC Function

$ALPHABETIC evaluates to a value of True if a specified alphanumeric item is alphabetic; for example, it consists solely of the uppercase letters A through Z, lowercase letters a through z, and blanks. It evaluates to a value of False if the alphanumeric item is not alphabetic. If the value of the alphanumeric item is null, the function evaluates to a value of unknown.

This function has the following format:

$ALPHABETIC(x)

The identifier of an alphanumeric field or group.

Example

IF $ALPHABETIC (ITEM‑DESC) THEN

	   DO PROC‑ITEM‑DESC
	 ELSE
	DO ITEM‑DESC‑ERR
   ENDIF  

If the identifier to test is nullable, test for null values (for example, IF identifier IS NULL ...) before testing with $ALPHABETIC. The function evaluates to Unknown if the value of the identifier is null.

A field of all spaces is considered alphabetic.

The site administrator can change valid alphabetic characters for a site in the PMS table PMSTBLS.