Trailing spaces

[bigjohn4k]

I tried to trim off trailing blanks with the following query but it does not work:

UPDATE AcctActivity SET AcctActivity.Description = Trim([description]), AcctActivity.Symbol = Trim([symbol]);

Any suggestion would be appreciated!

 

[CasperTFG]

I would try this

UPDATE AcctActivity SET AcctActivity.Description = Trim(AcctActivity.Description), AcctActivity.Symbol = Trim(AcctActivity.Symbol);

But What I can tell you is IF you designed the tables with a set length, then it will always pad to that length.
Craig: mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

!!If my post was helpful? Let me know!!
Click Here
| | | |
V V V V