A developer has a source system provided by another company. One of the columns in a table has spaces before each piece of data and is in uppercase which makes the reports unreadable. How can this be solved in a data module?
What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#