When I Execute In Using Query Output Is Getting Correctly But When I Uses That Query In Store Procedure Is Not Getting Correctly

See more:

C#

in table record as follows

sno Descirption Hotelname Phoneno Roomrate Active
1 Accom1 Satarlodge 24745734/9840175805 SingleNonAC 500,Double AC 1000 A
2 Accom1 Sarvanalodge 24151212/9790578502 SingleNonAC 600 Double AC 1200 A
3 Accom2 Suryalodge 24851524/9852012312 SingleNonAC 1000 DoubleAC 1600 A
4 Accom2 kalpanlodge 24221222/9844121252 AC 1200 A

when i execute in using query output is getting correctly but when i uses that query in store procedure is not getting correctly

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER proc [dbo].[Shortcode_Accom] (@Keyword varchar(10))
as

declare @Hotel varchar(25),
@Phone varchar(25),
@Room varchar(25),
@final varchar(max)

select @Hotel=Hotelname,@Phone=Phoneno,@Room =Roomrate from Tb_Accommodation where Active <> 'D' and description = @Keyword

if(@Hotel!='')
begin
Set @final = 'Dear Students HIMT Hotel Accommodation is ' +@Hotel+',' +@Phone+ ','+@Room+ ' by marine'
select @final
end

When i execute the above store procedure output as follows

exec [Shortcode_Accom] 'Accom2'

Dear Students HIMT Hotel Accommodation is kalpanlodge,24221222/9844121252,AC 1200 by marine


i am executing the select query as follows

select Hotelname,Phoneno,Roomrate from Tb_Accommodation where Active <> 'D'and description = 'Accom2'

when i execute the above query output as follows
Suryalodge 24851524/9852012312 SingleNonAC 1000 DoubleAC 1600
kalpanlodge 24221222/9844121252 AC 1200

but when i execute using Store procedure

exec [Shortcode_Accom] 'Accom2'

Dear Students HIMT Hotel Accommodation is kalpanlodge,24221222/9844121252,AC 1200 by marine

please help me what is the mistake i made?

regards,
narasiman P.