Let's see some of the Sytem inbuilt functions in SQL Server

SQL
 ------- 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')
Cheers,
Venkatesan Prabu .J
Head - KaaShivInfotech
www.KaaShivinfotech.com