The ALPHA function checks if a string is made of alphabetic characters entirely.
The ALPHA function is helpful to check if any string has characters other than alphabetic like special characters, escape sequences, the null value, etc.
Syntax
ALPHA(“str.expr”)
If a string is made entirely of alphabetic characters, the function returns 1.
If a string has numeric or other characters, the function returns 0.
If a string is empty or has a null value, the function returns 0.
The ALPHA function returns zero instead of converting the characters.
Examples
String contains a numeric character
ALPHA.RESULT will have value 0.
ALPHA.RESULT = ALPHA("AB2")
String contains only alphabetic characters
ALPHA.RESULT will have value 1.
ALPHA.RESULT = ALPHA("ABC")
An Empty String
ALPHA.RESULT will have value 0.
ALPHA.RESULT = ALPHA("")
ALPHA empty examples functions string syntax
