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