SQL ASCII Function
If you want to find a numerical value of a character which is in range of 0 to 255 you can use SQL ASCII function.
SQL String Functions
SQL CHAR or CHR Function
SQL CHAR or CHR function converts an integer in range 0-255 into a ASCII character.
SQL CONCAT Function
SQL CONCAT function is used to concatenate two or more strings.
SQL LENGTH Function
SQL LENGTH function to get the length of a string we can use SQL LENGTH or LEN function.
SQL REPLACE Function
SQL REPLACE function replaces every occurrence of the string specified as the searched string with the replacement string.
SQL UPPER and LOWER Functions
SQL Upper and Lower functions allow you change the uppercase and lowercase of a string.
SQL SUBSTRING
In order to get a part of a string we can use SQL SUBSTRINGfunction.