I can't update values in a column with their trimmed version. Why?

Question

Hi,

I have a Microsoft Access database. In the database, there is a table, say 'MyTable'. In MyTable, there is a column, say 'MyColumn'. Its type is Text. Some data in this column have several space characters at their end, so I want to trim them. I ran the command below

UPDATE MyTable SET MyColumn = trim(MyColumn)

The command was executed successfully, but I see no change. The data with space suffix are still there. Why?

Many thanks in advance,

Haris

Answer 1

One option is that you have a fixed-length field (which can be created programmatically). Another is that your spaces aren't true spaces but other characters (NBSP for instance) which just 'look' like spaces.