sql trim function in where clause

SQL TRIM Function

Remove leading and trailing spaces from a string:

SELECT TRIM('     SQL Tutorial!     ') AS TrimmedString;

The TRIM() function removes the space character OR other specified characters from the start or end of a string.

By default, the TRIM() function removes leading and trailing spaces from a string.

Note: Also look at the LTRIM() and RTRIM() functions.

TRIM([characters FROM ]string)

Remove leading spaces from a string:

SELECT LTRIM('     SQL Tutorial') AS LeftTrimmedString;

The LTRIM() function removes leading spaces from a string.

Note: Also look at the RTRIM() function.

LTRIM(string)