Page History
...
Returns the ASCII value of the first character in the string. This method returns an int.
Example
| Code Block |
|---|
SELECT Fname, ASCII(Fname) FROM Employee |
...
BIT_LENGTH
Returns the number of bits in a string.
Example
| Code Block |
|---|
SELECT Fname, BIT_LENGTH(Fname) FROM Employee |
LENGTH
Returns the number of characters in a string.
Example
| Code Block |
|---|
SELECT City, LENGTH(City) FROM Employee |
CHAR
Returns the character that represents the ASCII value.
Example
| Code Block |
|---|
SELECT CHAR(65) FROM Employee |
...
CONCAT
CONCAT combines strings.
Example
| Code Block |
|---|
SELECT CONCAT(Fname, SPACE(3), City) FROM Employee |
DIFFERENCE
Returns the difference between the sounds of two strings.
Example
| Code Block |
|---|
SELECT DIFFERENCE(Fname, City) FROM Employee |
LOWER
Converts a string to lowercase.
Example
SELECT LOWER(Fname) FROM Employee
...