Description

Returns TRUE if all of the characters in the string are within the range

Syntax

HAS_ALL_CHARS(s1, n2, n3)

●      s1: a string

●      n2: the letter or decimal value of the first character in the range

●      n3: the letter or decimal value of the last character in the range

Example

HAS_ALL_CHARS(“Hello”, “a”, “z”)          ® FALSE

HAS_ALL_CHARS(“HELLO WORLD”, “A”, “Z”)     ® FALSE

HAS_ALL_CHARS(“HELLOWORLD”, “A”, “Z”)      ® TRUE

Note

Range is determined by the ASCII chart which includes only uppercase or lowercase letters (no numbers, spaces, punctuation, or special characters) in “A”-“Z” or “a”-“z” ranges.