Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ISALPHA
Functions and Expressions Reference Guide
132
ISALPHA
The ISALPHA function tests a text object to see if it is contains all alphabetic
characters.
Syntax
ISALPHA (single-text-expression)
Meaning
ISALPHA (text_to_test)
Returns
This function returns TRUE or FALSE
If text_to_test contains only alphabetic characters (for example, A-Z and a-z),
ISALPHA evaluates to TRUE.
If text_to_test contains other than just alphabetic characters,
ISALPHA returns
FALSE.
Examples
ISALPHA ("AnywhereUSA")
Returns TRUE.
ISALPHA ("Anywhere USA")
Returns FALSE.
ISALPHA ("Mr. Brown")
Returns FALSE.
Uses
Use
ISALPHA when you need to know whether a text string is all alphabetic
characters.
Related Functions
ISLOWER, ISNUMBER, ISUPPER, LEAVEALPHA, LEAVEALPHANUM,
LEAVENUM, LEAVEPRINT