USFormat.IsAlphanumeric

Previous Next

Tests if a string is made up entirely of alphanumeric characters, or not. An alphanumeric character is a character in one of the ranges A-Z, a-z, 0-9.

Returns the number 1 if the string is alphanumeric, and the number 0 otherwise.

Syntax

SELECT USFormat.IsAlphanumeric(
          string
)