Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

SQL Server ISALPHA function


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)


Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service