trim(string text[, characters text])

Let us now check the trim(string,char) function with the following query.

Query

default> select trim('tutorialspoint','t') as trim_char; 

Result

The above query will generate the following result.

trim_char 
------------------------------- 
utorialspoin 

Here, the char ’t’ is trimmed from ‘tutorialspoint’.