ContainsAlpha() mvSQL database function in Jitterbit App Builder¶
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