>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 too, but it's not the answer. The key word was "trailing" which implies that there may be some that are not trailing.