Find the count of Lowercase, Uppercase, Special Characters?

There an example here. https://stackoverflow.com/questions/15289351/tsql-count-uppcase-and-lowercase-letters

With a brief modification

Output:

There are 3 Special Characters
There are 19 lower-case letters
There are 4 upper-case letters

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan8y ago
There an example here. https://stackoverflow.com/questions/15289351/tsql-count-uppcase-and-lowercase-letters

With a brief modification
DECLARE @name VARCHAR(200) ='I am DB Developer @c-sharp.com'
DECLARE @i int = 1
DECLARE @numVowels int = 0
DECLARE @numLower int = 0
DECLARE @numUpper int = 0

WHILE @i <= LEN(@name)
    BEGIN
        IF PATINDEX('%' + LOWER(SUBSTRING(@name, @i, 1)) + '%', '!@#$%^&*()-.') > 0
            BEGIN
                SET @numVowels += 1
            END
        IF SUBSTRING(@name, @i, 1) COLLATE Latin1_General_BIN BETWEEN 'a' AND 'z'
            BEGIN
                SET @numLower += 1
            END
        ELSE IF SUBSTRING(@name, @i, 1) COLLATE Latin1_General_BIN BETWEEN 'A' AND 'Z'
            BEGIN
                SET @numUpper += 1
            END
        --PRINT SUBSTRING(@name, @i, 1)

        SET @i +=1
    END


PRINT 'There are ' + CAST((@numVowels) AS VARCHAR(200)) + ' Special Characters'
PRINT 'There are ' + CAST((@numLower) AS VARCHAR(200)) + ' lower-case letters'
PRINT 'There are ' + CAST((@numUpper) AS VARCHAR(200)) + ' upper-case letters'
Output:
There are 3 Special Characters
There are 19 lower-case letters
There are 4 upper-case letters
0
Kapil Singh Kumawat8y ago
If you are using special characters then its good to use NVARCHAR datatype.
Replace VARCHAR with NVARCHAR.
It will work.
0
Shubham Kule8y ago
Change data type and use nvarchar(100)
0