SQL – MySQL LTRIM() Function
The MySQL LTRIM() function removes leading spaces from a string.
SQL – MySQL MID() Function
The MySQL MID() function extracts a substring from a string, starting at any position from the beginning or end of the string.
SQL – MySQL POSITION() Function
The MySQL POSITION() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL REPEAT() Function
The MySQL REPEAT() function repeats a string as many times as specified.
SQL – MySQL REPLACE() Function
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
SQL – MySQL REVERSE() Function
The MySQL REVERSE() function reverses a string and returns the result.
SQL – MySQL RIGHT() Function
The MySQL RIGHT() function extracts a number of characters from a string, starting from right.
SQL – MySQL RPAD() Function
The MySQL RPAD() function right-pads a string with another string, to achieve a specified length.
SQL – MySQL SPACE() Function
The MySQL SPACE() function returns a string of the specified number of space characters.
SQL – MySQL SUBSTR() Function
The MySQL SUBSTR() function extracts a substring from a string, starting from any position.
SQL – MySQL SUBSTRING() Function
The MySQL SUBSTRING() function extracts a substring from a string, starting from any position.
SQL – MySQL SUBSTRING_INDEX() Function
The MySQL SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs.
SQL – MySQL TRIM() Function
The MySQL TRIM() function removes leading and trailing spaces from a string.
SQL – SQL Server ASCII() Function
The SQL Server ASCII() function returns the ASCII value for the specified character.
SQL – SQL Server CHAR() Function
The SQL Server CHAR() function returns the character based on the ASCII code specified.
SQL – SQL Server CHARINDEX() Function
The SQL Server CHARINDEX() function searches for a substring in a string, and returns the position. If the substring is not found, this function returns 0.