LTRIM and RTRIM does not work sometimes if the whitespace character is not actually character ASCII 32. This stumped me for a while. The data entry screen used to enter the information somehow allows users to enter other white space characters other than the regular space from the space bar. It could be related to the system encoding, I don’t know. Here is the code I used to fix the LTRIM and RTRM.

Ltrim Rtrim don’t always work