SQL Server has in build function REVERSE to reverse string. A T-SQL example is given below
The function is very much direct. It takes an input string and returns the reversed string.
Another solution to reverse a string without using REVERSE function is given below
CREATE FUNCTION [dbo].fn_reversestring
(
@string nvarchar(max)
)
RETURNS TABLE AS RETURN
(
WITH T1(number) AS (SELECT 1 UNION ALL SELECT 1),
T2(number) AS (SELECT 1 FROM T1 AS a cross join T1 as b),
T3(number) AS (SELECT 1 FROM T2 AS a cross join T2 as b),
T4(number) AS (SELECT 1 FROM T3 AS a cross join T3 as b),
Nums(number) AS (SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL))
from T4)
SELECT STUFF(
(SELECT '' + SUBSTRING(@string,Nums.number,1)
FROM Nums order by Nums.number desc
FOR XML PATH('')),1,0,'') As ReversedString
)
The above function is an inline table valued function which uses tally table to reverse the input string. The logic is pretty simple. The statement SUBSTRING(@string,Nums.numer,1) breaks the string into rows of alphabets and then the string is concatenated in descending order. The output of the function is given below.
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
