mvSQL Database Function - ContainsAlpha()¶

Summary¶

Determines whether an expression contains an alphabetic character (a-z). Returns 1 or 0.

Syntax¶

ContainsAlpha(<Expression>)

Parameters¶

Expression An expression that is a string type

Returns¶

Returns 1 if Expression is an alphabetic character (a-z), 0 if it is not

Examples¶

SELECT 1 WHERE ContainsAlpha('MyName') = 1

Returns 1