General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only