20. How to use TRIM FUNCTION in SQL

Описание

The SQLite trim() function removes specified characters at the beginning and the end of a string. If you don’t specify the characters to remove, the trim() function will remove space characters by default.
Note that the trim() function does not remove other whitespace characters by default.

Syntax
TRIM( ‘string’, character)
(00:00) Introduction.
(02:00) Using TRIM function.
(02:14) Using LTRIM function.
(03:29) Using RTRIM function.

for downloading the SQL Lite Studio, click this link below:
https://sqlitestudio.pl/
For downloading the Sample Database click this link below :
https://github.com/Sia4Tech/SQLITE-Files

to watch other videos of this course check this linke below:
https://youtube.com/playlist?list=PLX21EEATqSVJacpp9mrJLLyQSebaZafZw

for more videos visit:
https://www.sia4tech.com

#sia4tech
#siafortech


"Music from: www.bensound.com"
"Royalty Free Music from Bensound"