SQL Trim()

TRIM function removes a given character from left and right from a give string.

trim('term to terminated from string' from String_name)

Online Execute/Compile
Select trim('T' from name) as GOOD FROM customers ;