I want to split the name and put the same in rows, as shown below
KUMAR RAHUL SANU
can somebody share the sql code to achieve the this.
Here is an article that contains lots of methods to split a function in T-SQL. https://sqlperformance.com/2012/07/t-sql-queries/split-strings
Use Jeff Moden's String Splitter function