SQL String Functions 8 Top SQL Queries

Here are eight top SQL string functions. These include Length, TRIM, Concatenate, Trailing, CHAR, LPAD, RPAD, and Soundex.

SQL String functions

How to Use Built-in String Functions

#1 Length

Select LENGTH (first_name) 
from my_employee;

The above query counts the FIRST_NAME of all characters that include spaces.

#2 TRIM

Explained with examples of TRIM functions.

#3 Concatenate

Select first_name 
|| last_name 
from my_employee;

#4 Trailing Functions

Select Trim (trailing 
'y' from first_name) 
from my_employee;

Trailing is case-sensitive.

#5 CHAR Function

Here are the best examples of the CHAR function you can find here.

#6 and #7 LPAD and RPAD

You can find here examples for RPAD and LPAD

#8 Soundex

Select Soundex(first_name) 
from my_employee;

The above example converts ‘Srinimf’ into an Alpha-numeric value.

Audio Post

Related Posts

• LOCATE Function for Use in SQL Queries
• UPPER and Lower Functions in any SQL
• LPAD and RPAD functions