SQL String Functions – SQL Tutorial | Software Testing Material

SQL String Functions:

In this post, we see SQL String Functions in detail.

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 white space from the beginning of the string
RTRIM() – It is to remove all white space at the end of the string
CONCAT() – Concatenate function combines multiple character strings together.
REPLACE() –  To update the content of a string.

Let’s see each String function in detail.

LEN():

Syntax:

Example:

SQL String Functions Length

LOWER():

Syntax:

Example:

SQL String Functions Lower

UPPER():

Syntax:

Example:

SQL String Functions Upper

SUBSTRING() :

Syntax:

Example:

SQL String Functions Substring

LTRIM:

Syntax:

RTRIM:

Syntax:

CONCAT:

Syntax:

SQL String Function Concatination

REPLACE:

Syntax:

SQL String Function Replace

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

Get our latest blog posts delivered to your inbox

Subscribe and get popular blog posts about software testing industry.

Rajkumar

Leave a Comment

Share via
Copy link
Powered by Social Snap