How to use the BTRIM() function in SQL

Overview

The BTRIM() function is used to trim all the specified characters in the string_trim argument from the beginning and the end of the given string.

Syntax

STRPOS(string,string_trim)

Note: If the string_trim argument is not specified, the leading and trailing space is removed.

Parameter

string: This represents the string to be searched.
string_trim: This represents the characters to be removed.

Example

Let’s assume we have a dataset called Writer, and it contains information about several writers’ names, genders, and the states in which they were born. However, when we fetch the data from the database, we notice that a string back and kacb has been added to the writers’ names. How do we solve this problem?

Well, we can solve this problem using the BTRIM function.

The following code shows how we can do this:

CREATE TABLE Writer (
    id int,
    name varchar(50),
    gender varchar(10),
    state varchar(15)
);
-- Insert data
INSERT INTO Writer
VALUES (01,'backSharon Pellerkacb','Female','Kogi');
INSERT INTO Writer
VALUES (02,'backPaul Donskacb','Male','Lagos');
INSERT INTO Writer
VALUES (03,'backAmeera Abedayokacb','Female','Imo');
INSERT INTO Writer
VALUES (04,'backMaria Elijahkacb','Female','Lagos');
INSERT INTO Writer
VALUES (05,'backDavid Hassankacb','Male','Abuja');
INSERT INTO Writer
VALUES (06,'backNiniola Disukacb','Female','Lagos');
INSERT INTO Writer
VALUES (08,'backJoe Smithkacb','Male','Lagos');
-- Query 
SELECT id, name, BTRIM(name, 'back') AS new_name, gender
FROM Writer;

How to use the BTRIM() function in SQL

Overview

Syntax

Parameter

Example

Explanation