Some inbuilt functions in SQL Server

Let's see some of the Sytem 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')

Cheers,
Venkatesan Prabu .J
Head - KaaShivInfotech
www.KaaShivinfotech.com