Try using, trim( trailing '.' from trim( col1 ) )
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2005 Indexes