Monday, 14 November 2016

SQL SERVER CHAR FORMULA

SQL SERVER CHAR FORMULA

--alright viewers, we will be looking at the CHAR function using SQL SERVER SSMS

--the CHAR function displays the character symbol for the number you embed in its brackets.

--let us begin

SELECT CHAR(67);

--as you can see the character symbol for the integer of 67 is a capital C.

--let us try some other numbers and see what the come up with.

SELECT CHAR(255);

--you can see that the integer of 255 comes up with a letter like y but in a foreign language.

--let's try one last one

SELECT CHAR(253);

--this one gives a slightly different variation of the letter y.
--that is it.

No comments:

Post a Comment