Line Break using sql

Date Time Add
--------------------

SELECT DATEADD(hour, 3, GETDATE())
SELECT DATEADD(MINUTE, (60 * 1.5), '11:00 AM')


Get Previous date
-----------------------------------------------------------------------------------
  select convert(datetime, convert (varchar(10), getdate(), 101)) - 1 as pdate


Line break using sql
-----------------------------------------------------------------------------------


  select Resourceid+CHAR(10) + CHAR(13) +'raja' as name, *  from Tbl_name