without using reverse find the given string palindrome or no

venkatesh duddukuri

10y1.7kSQL

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)

begin

if @word=REVERSE(@word)

print 'pal'

else

print 'not pal'

end

Thanks

Venkatesh D

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar10y ago
Accepted 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 <= LEN(@word)
BEGIN
SET @Result = SUBSTRING(@word,@i,1) + @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 Vellanki10y ago
declare @num varchar(20)='sasa'
declare @rev varchar(20)=''
Declare @i int=1
Declare @count int
SET @count=Len(@num)
While(@i<=@count)
Begin
SET @rev=SUBSTRING(@num,@i,1) +@rev
SET @i=@i+1
end
print @rev
if(@num=@rev)
Print 'palindrom'
else
print 'is not palindrom'
Vivek Kumar10y ago
Welcome Venkatesh
venkatesh duddukuri10y ago
hai... vivek kumar

Thanks answer is currect.

Thanks and regards
Venkatesh D
Ravi Patel10y ago
Hi ,

check this

http://www.programmingsimplified.com/c-program-find-palindrome
Joginder Banger10y ago
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 < @length
BEGIN
select @tempvalue+= SUBSTRING(@YourValue, @length-@site_value,1 )

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 Punhani10y ago
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.