Give me en example to use TRIM function in SQL..

Question

In SQL string function TRIM. Syntax TRIM(string). I need a Query example of using TRIM function.

Answer 1

SELECT TRIM(' This string is padded with spaces ');

Result:
This string is padded with spaces

NOTE: The trailing and leading spaces is removed from the result.

Answer 2

LTRIM function shows same result.

https://www.w3schools.com/sql/trysqlserver.asp?filename=trysql_func_sqlserver_trim2

I got this thank you Ipang