Hi Raju,
Use this:
DECLARE @Res VARCHAR(50)
SET @Res=(SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + CHAR(10)
+ US_Area
+ CHAR(13) + CHAR(10)
+ US_City
+ CHAR(13) + CHAR(10)
+US_Country
+ CHAR(13) + CHAR(10)
+US_Mobile
AS Address FROM TBL_User where US_ID=34)
PRINT @Res
Select statement will select the data in table, hence, it won't display in new line.
Try this:
SELECT US_Hno + ', ' + US_Street
+ CHAR(13) + '</br>'
+ US_Area
+ CHAR(13) + CHAR(10)
+ US_City
+ CHAR(13) + CHAR(10)
+US_Country
+ CHAR(13) + CHAR(10)
+US_Mobile
AS Address FROM TBL_User where US_ID=34
--Amit