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

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

Leave a Comment

Share via
Copy link
Powered by Social Snap