Home 2017 November SQL Puzzle: SQL Advance Query – Find the count of Lowercase, Uppercase, Special Characters

SQL Puzzle: SQL Advance Query – Find the count of Lowercase, Uppercase, Special Characters

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input string and expected output for counting the total Lowercase, Uppercase and Other Characters (Including SPACE) in the given string.

Input String:

Expected Output:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Puzzle: SQL Advance Query - Find the Sum of privious values without using a self-joinSQL Puzzle: SQL Advance Query - Delete duplicate without using RANK, PARTITION, ROW NUMBER
Comments: 1
  1. Dpan
    April 23, 2019 at 11:43 am

    DECLARE @str AS VARCHAR(100) = ‘I am Anvesh Patel, owner @str DBRND.COM’,@i as int=1,@lengthOfstr as int,@getString as nvarchar(max),
    @sumOfUpper as int,@sumOfLower as int,@sumOfOtherChar as int
    set @lengthOfstr=LEN(@str);set @sumOfUpper=0;set @sumOfLower=0;set @sumOfOtherChar=0;
    while (@i<=@lengthOfstr)
    begin
    select @getString= SUBSTRING(@str,@i,1)
    select @sumOfUpper+=case when ASCII(@getString) between 65 and 90 then 1 else 0 end;
    select @sumOfLower+=case when ASCII(@getString) between 97 and 122 then 1 else 0 end;
    select @sumOfOtherChar+=case when (ASCII(@getString) not between 65 and 90 and ASCII(@getString) not between 97 and 122) then 1 else 0 end;
    set @i=@i+1;

    end
    print (Concat('Upper char–', @sumOfUpper))
    print (Concat('Lower char–', @sumOfLower))
    print (Concat('Other char–', @sumOfOtherChar))

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

November 21, 2017 1 Comment SQL Puzzle, , , , , , , , , , , , ,