Dec 6, 2014 · In that blog post I wrote a function which would reverse an entire string. However, recently I read a question in SQLBangalore where the user wanted to reverse string, but wanted to keep all the words in the same order. For example, If the string is – “I am Pinal Dave”, it should be reversed as “Dave Pinal am I.”

There are at least two ways to do this. You mention CTE in your title, so I'll go with that first. From the link here I have an example of a hiererchical CTE, a little massage and it will represent the parents rather than children: SELECT Group_ID, Name, Parent_ID, Level. FROM T_Group. WHERE Contact_id = @Leaf.

May 30, 2017 · set @O=@O+' '+REVERSE(@T) set @I=left(@i,len(@i)-(1+len(@t))) If CHARINDEX(' ',@I)=0. set @O=@O+' '+@i. select @o. end. 'If' block is added to append the last word, as the 'Empty Space' will not be available to append the last word in the sentence. Modified: @string NVARCHAR(MAX), . @delimiter CHAR(1) . DECLARE @start INT, @end INT .

You can create one small function in SQL to reverse a string like below: IF CHARINDEX(' ', @source) > 0. BEGIN. SET @dest = SUBSTRING(@source,0,CHARINDEX(' ', @source)) + ' ' + @dest. SET @source = LTRIM(RTRIM(SUBSTRING(@source,CHARINDEX(' ', @source)+1,LEN(@source)))) END. ELSE. BEGIN. SET @dest = @source + ' ' + @dest. SET @source = '' END.

Sep 23, 2014 · In this post "Reverse string in sql server", we will reverse a string with the help of a recursive CTE with explanation of recursive cte steps.

Oct 1, 2020 · To reverse any statement Word by Word in SQL server we could use the SUBSTRING function which allows us to extract and display the part of a string. Pre-requisite :SUBSTRING function. Approach : Declared three variables (@Input, @Output, @Length) using the DECLARE statement. Use the WHILE Loop to iterate every character present in the @Input.

Dec 17, 2014 · In this blog post we will be seeing the solution proposed by Yuri Petrov in this blog post. Yuri’s script is in two parts. Part 1: Create a auxiliary table with numbers. FROM sys.columns a. Part 2: Script to Reverse String Words. If you want, you can convert this script to function afterwards.

How to write a SQL Server Query to reverse every word present in a string with an example? The reverse string is one of the standard Interview Questions you might face interviews. The SUBSTRING function allows you to extract and display the part of a string.

Dec 31, 2024 · Learn what a SQL Server CTE is with examples and how to write a TSQL CTE for select, insert, delete and updates logic.

Sep 1, 2012 · SET @dest = @source + ' ' + @dest. SET @source = '' END. Char(44) is the ASCII value for , so at last I am just replacing that character. This will print Bohr Albert Planck. If you use a split string function like this you can do something like this. select ltrim(s)+' ' from dbo.Split(',', @S) order by pn desc. for xml path(''), type. SQL Fiddle.