Find the count of Lowercase, Uppercase, Special Characters?

Question

DECLARE @str AS VARCHAR(100) = 'I am DB Developer @c-sharp.com' How to acheive this?

Bryian Tan · Answer

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 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

Kapil Singh Kumawat · Answer

If you are using special characters then its good to use NVARCHAR datatype. Replace VARCHAR with NVARCHAR. It will work.

Shubham Kule · Answer

Change data type and use nvarchar(100)