Aug 13, 2017
1 min read
3 Popular SQL String-functions
String-functions are popular in SQL-Queries. These are built-in functions. Below is the list to use as a reference.
The function UPPER-It converts a string into the UPPER case.
Syntax.
UPPER (Column_name)
The LOWER function-It converts string into lower case.
Syntax:
LOWER (Column_name)
The INITCAP function-It converts the first letter into CAPITAL.
Syntax:
INITCAP(Column_name)
The trim functions. Read examples online here.
The LTRIM. It looks for the left side of the String.
Syntax:
LTRIM(column_name,’*’);
The RTRIM. It looks for right side of the string.
Syntax:
RTRIM(column_name,’*’);
Sources
