Need Help With Ascii () And Char() Functions

Hello one and all,

I’m new to T-sql and need help understanding the CHAR() and ASCII functions.
I tried to run these commands to better understand them but I get the same results each time.
Here is the query with the char command

USE Northwind
SELECT FirstName + ' ' + LastName, + CHAR(13) + Address,
+ CHAR(13) + City, + Region
FROM Employees
WHERE EmployeeID = 1


Nancy Davolio
507 - 20th Ave. E.
Apt. 2A
Seattle WA

(1 row(s) affected)

Here is the same command without the char function.

USE Northwind
SELECT FirstName + ' ' + LastName, + address, + city, + region
from employees
where employeeID = 1

address city region
------------------------------- ------------------------------------------------------------ --------------- ---------------
Nancy Davolio 507 - 20th Ave. E.
Apt. 2A Seattle WA

(1 row(s) affected)


As you can see I get the same results back except for the column names being displayed.

Please help me understand this.

Thank you,

Eric Talley