>good morning to all!
>
>I don’t know if I did not notice or did not bother me before, but when I SELECT from SQL server as :
>…ALLTRIM(FIRST)+' '+ALLT(MIDDLE)+'. '+ALLTRIM(LAST)AS NAME,….
>the field is returned with all the trailing spaces from the original length of the field which is 153 char long. (I can’t imagine anybody having such long last name…let along pronounce it)
>So everytime I want to see the next field in the cursor I have to scroll to the right.
>What is the best way to bring only the name without the trailing spaces?

SQLServer does not have an ALLT()
use RTRIM() instead and it should behave as you wanted.
regards