------- 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')
|