without using reverse find the given string palindrome or no

Question

hai... i trying to using REVERSE() find the given string palindrome or not but i got answer without using REVERSE() fun find palindrome or not PLZ any one help me . create procedure pal @word varchar(50) as begin if @word=REVERSE(@word) print 'pal' else print 'not pal' end go Thanks Venkatesh D

Vivek Kumar · Answer

Hi Venkatesh Below is the solution for your question. CREATE PROCEDURE pal @word varchar(50) as begin DECLARE @i int @Result varchar(max) SET @Result='' SET @i = 1 WHILE @i BEGIN SET @Result = SUBSTRING(@word@i1) + @Result SET @i=@i + 1 END if @word=@Result print 'pal' else print 'not pal' end go --------------------------------------------------- If this post helps you mark it as answer

Satish Vellanki · Answer

declare @num varchar(20)='sasa' declare @rev varchar(20)='' Declare @i int=1 Declare @count int SET @count=Len(@num) While(@i Begin SET @rev=SUBSTRING(@num@i1) +@rev SET @i=@i+1 end print @rev if(@num=@rev) Print 'palindrom' else print 'is not palindrom'

Vivek Kumar · Answer

Welcome Venkatesh

venkatesh duddukuri · Answer

hai... vivek kumar Thanks answer is currect. Thanks and regards Venkatesh D

Ravi Patel · Answer

Hi  check this http://www.programmingsimplified.com/c-program-find-palindrome

Joginder Banger · Answer

Hi  venkastesh as per your requirement make a store procedure please check and let me know.. alter proc testing @YourValue varchar(max)='PAP' as begin if(@YourValue is not null) begin declare @length int; declare @tempvalue varchar(max)='' declare @site_value int; set @length=len(@YourValue); SET @site_value = 0; WHILE @site_value BEGIN select @tempvalue+= SUBSTRING(@YourValue @length-@site_value1 ) SET @site_value = @site_value + 1; end if(@tempvalue=@YourValue) begin print 'palindrome value' end else begin print 'Not a valid value' end end else begin print 'Please enter valid value'; end end

Rajeev Punhani · Answer

Hi Venkatesh You can reverse the string without using reverse function by creating function.See the link below for the same. http://www.c-sharpcorner.com/code/1308/reverse-string-in-sql-server-without-reverse-function.aspx If the above solution is helpful then accept the answer.