>>use LEFT() and ATC()
>
>That's why I was asking if someone already did a function for that. I am looking for something simple. If there is nothing that I'll have to built my own functions. Thanks.
I think maybe alltrim(substr(x,1,at(chr(13),x)-1))
Basically remove the CR then trim.
Tom