开发者

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

开发者 https://www.devze.com 2023-01-09 14:55 出处：网络

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 c

相关专题：ms-access

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 succes开发者_开发百科sfully, but I see no change. The data with space suffix are still there. Why?

Many thanks in advance,

Haris

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.