SQL SERVER ASCII FORMULA

SQL SERVER ASCII FORMULA

--HI ALL, TODAY WE ARE LOOKING AT THE ASCII FUNCTIONS IN SQL SERVER

-- LET'S BEGIN

-- I WILL USE THE PHONE COLUMN FROM THE DIMCUSTOMER TABLE
SELECT Phone, ASCII(PHONE) as [ASCII]
FROM AdventureWorksDW2012.dbo.DimCustomer;

--I HAVE EMBEDDED THE PHONE COLUMN IN THE ASCII FORMULA

--I HAVE ALSE DISPLAYED THE PHONE COLUMN WITHOUT ANY FORMULA SO THAT YOU CAN SEE THE DIFFERENCE

-- NOW I WILL RUN THE QUERY, BY HIGHLIGHTING THE SQL QUERY AND RUNNING IT

-- YOU CAN SEE THE ASCII VALUE IS BASED ON THE FORMAT OF THE PHONE NUMBERS

--THAT IS IT.