Some inbuilt functions in SQL Server

 ------- RETURNS ASCII VALUE FOR THE 
CHARACTER

SELECT ASCII('A')



------- RETURNS ASCII VALUE FOR THE FIRST CHARACTER OF 
THE STRING

SELECT ASCII('ASK')



------- CONVERT YOUR CAPITAL LETTERS TO SMALL 
LETTERS

SELECT LOWER('ASK')



------- CONVERT YOUR LOWER LETTERS TO UPPER 
LETTERS

SELECT UPPER('ask')



------- GIVES YOU THE LENGTH OF THE 
STRING

SELECT LEN('ask')