SQL Query | How to extract Odd / Even numbered characters from a string | Recursive CTE

In this video, we discuss how to extract odd / even numbered characters from a string.

Video tutorial on STRING_AGG function

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[VinayKumar-lblq]

Thanks for this recursive cte example.

[ykirankumar]

Declare @name varchar(20) ='KiranKumar';

with cte as
(
select 1 as t
union all
)
select string_agg(ch, ' ')

[briandennehy]

Great, recursion is very powerful and useful

[kristyowens]

Please do a separate detailed video on Recursion and dynamic SQL.

[hv]

Wonderful explanation. So easy to follow. Waiting for more videos from you!

[diydecor]

Please post more examples in recursive and dynamic ctes.