Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

This documentation is for version 3.3 and earlier of Vinyl, the former name for App Builder. Access the latest documentation here.

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