The reason for the bug was that X'00' is a terminal symbol. If the char set contained X'00', all other characters after its (inculding itself) are then ignored. Closes #3543 ...
Returns a string expression after it removes leading blanks.
This is a simple explanation on how to use the SQL Server TRIM, LTRIM and RTRIM Function.