I used PADR(origin,40) to make sure the names in the column chow up since I was using a SELECT. As you know, if the first name comes in with 4 letter, all the otrher names in that column will be truncated and have four letters. It ain't woking. I still get the truncation. I even tried, PADR(origin, 40, " "). Still didn't work. Do I need to SET something to ON or OFF?
Thanks in advance for your help! :-)
Randall L. Johnson