SQL Server ASCII and CHAR functions, including tabs and carriage returns

In this video, we will be looking at how to convert single characters to numbers and back. This also includes non-printing characters, such as tabs, line and carriage returns.
My SQL Server Udemy courses are:
----
My Excel for PC courses are:
----
In this video, we will look at:
ASCII - converting a single character to a number between 0 and 127 (or 0 and 255)
CHAR - converting a number between 0 and 255 to a single character. This includes CHAR(9) which is a tab, CHAR(10) which is a
NCHAR - converting a number from 256 upwards to a single Unicode character.
UNICODE - converts a single character from the extended character set to a single number.

[prateeksharma]

Thanks. i was able to do case sensitive search in sql by comparing ascii values of alphabets after watching your video.

[hasanmougharbel]

Hey there, glad to meet again.
God bless you efforts.
As new to sql i have a new enquiry.
I have learned recently that text is compared based on the ASCII value of the text. My question is:
How 'c'(99) is between 'a'(97) and 'e'(101) but 'C'(67) is not between 'a'(97) and 'e'(101).
Thanks for taking care.

[nblljk]

How to convert a string of character in ascii like "hello" please ?