How to print even letters from a string using sql

Accepted answer

May be you should be trying it yourself.

Here is one hint:

https://www.c-sharpcorner.com/Forums/caluculate-sum-of-digits-in-sql

declare @passedString varchar(32) = 'MAHARAJA'

declare @index int = 1

declare @charvalue varchar(32) =''

-- Looping here

WHILE @index<= LEN(@passedString)

BEGIN

SET @charvalue = @charvalue + case when @index %2 = 0 then SUBSTRING(@passedString, @index, 1) else '' end

SET @index= @index+ 1 -- increment the loop value

END

select @charvalue

Thank you sir