Did anyone notice that these functions do not seem to work directly on a field? I always have to create a new one to use trim function on the original filed. Am I missing something?
I would like to avoid the repetitive process of manually creating additional fields when I have a table which needs TRIM.