SQL Puzzle | The ASCII Puzzle – II

This is variation of the puzzle (https://msbiskills.com/2015/04/25/t-sql-query-the-ascii-puzzle/).

In the puzzle we have an input string and we have to find ASCII value for each character present in the string and position of each character in the string.

Please check out the sample input and the expected output below-

Sample Input

DECLARE @ VARCHAR(1000)= ‘KJhdsfmdsnfsd sdkfjsdk fjsd ‘

Expected Output

Solution 1 | Using Numbers Table

--



DECLARE @ VARCHAR(1000)= 'KJhdsfmdsnfsd sdkfjsdk fjsd '
SELECT 
		Number Position , SUBSTRING(@,Number,1) Chr, ASCII(SUBSTRING (@,Number,1)) AsciiChr
FROM 
(
	SELECT 
		 DISTINCT Number 
	FROM 
		 Master..Spt_Values
	WHERE 
		 Number > 0 AND Number <= DATALENGTH(@)
)r


--

Add a comment if you have any other solution in mind. I would love to learn it. We all need to learn.

Enjoy !!! Keep Learning

Pawan Khowal 

Http://MSBISkills.com