What Are String Functions In Sql?

1.	What Are String Functions In Sql?
Answer» 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. SQL string functions are used primarily for string manipulation. Some of the widely used SQL string functions are:

Answer»

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.

SQL string functions are used primarily for string manipulation.

Some of the widely used SQL string functions are:

Discussion