Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trailing spaces

Status
Not open for further replies.

bigjohn4k

Technical User
Apr 7, 2002
2
US
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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top