SESSION NAME: SQL Functions - 2.
QUESTION NAME: ASCII - Value.
TABLE DESCRIPTION:
Usage of ASCII Value =
Returns the ASCII value for the
specific character.
ASCII(character or column name)
character = The character to return the ASCII value for. If
more than one character is entered, it will only return the
value for the first character
Display the name and the ascii value column
(ASCII(name)) from students table
Returns the ASCII value for the
specific character.
ASCII(character or column name)
character = The character to return the ASCII value for. If
more than one character is entered, it will only return the
value for the first character
Display the name and the ascii value column
(ASCII(name)) from students table
CODE:
select name, ASCII(name) from students;
0 Comments