how to write stored procedure for reverse string dynamically

Question

Prasham Sabadra · Answer

Hi Never tried but please check once - http://stackoverflow.com/questions/11930925/reversing-a-string-using-teradata-spl

Joginder Banger · Answer

create proc reverseStringVal(@value varchar(max)) as begin DECLARE @temp int; DECLARE @ret varchar(max) set @temp=len(@value) while(@temp>0) begin if(@ret is null) begin set @ret= SUBSTRING(@value@temp1) end else begin set @ret+= SUBSTRING(@value@temp1) end set @temp-=1 end select @ret end when run this store procedure I got result like this type. DECLARE @return_value int EXEC @return_value = [dbo].[reverseStringVal] @value = N'aidni ym evol I' SELECT 'Return Value' = @return_value GO output is I love my india