SQL string functions are used primarily for string manipulation. Some of the widely used SQL string functions are

☛ LEN() – It returns the length of the value in a text field

☛ LOWER() – It converts character data to lower case

☛ UPPER() – It converts character data to upper case

☛ SUBSTRING() – It extracts characters from a text field

☛ LTRIM() – It is to remove all whitespace from the beginning of the string

☛ RTRIM() – It is to remove all whitespace at the end of the string

☛ CONCAT() – Concatenate function combines multiple character strings together

☛ REPLACE() – To update the content of a string.