Everyone did assume his text was what he meant. The stated requirements did not say "keep only the first 28 chars" so LEFT(,28) would not be right.

>Sure. Difference is I would have asked rather than assume. Especially if it seemed unclear; but maybe it wasn't unclear to you.
>
>>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.