Hi Jay

Have you never had a client say one thing but mean another? It's not up to us to guess what the key word(s) are. It's our job to ensure there's no ambiguity in the client's requirements. Fernando's example may have been exactly what he meant. Fernando (the "client") acknowledged and corrected the ambiguity.

>>Yes, but given his example it works. If his stated requirements are wrong, attempting to just remove chr(13) etc from the end may also be wrong.
>
>Sure, but using LEFT(cString,28) would work to, but it's not the answer. The key word was "trailing" which implies that there may be some that are not trailing.