XLeratorDB/strings Online Documentation
ISALPHA
Updated: 30 April 2009
Use ALPHA to determine if a value contains only alphabetic characters [a-z][A-Z].
Syntax
SELECT [wctString].[wct].[ISALPHA] (
<@Text, nvarchar(max),>)
Arguments
@Text
is the text to be evaluated. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.
Return Types
bit
Remarks
· ISALPHA searches for [a-z][A-Z] and returns 0 if other than those values are found.
Examples
select wct.ISALPHA('ABC')
This produces the following result
-----
1
(1 row(s) affected)
select wct.ISALPHA('abc54qwerty')
This produces the following result
-----
0
(1 row(s) affected)
select wct.ISALPHA('ABC!')
-----
0
(1 row(s) affected)