>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?
Randall,
Padr(origin,40) does its job well. However I don't think you need it at all. I don't know exactly in what version it changed but truncation doesn't occur with select as before (couldn't reproduce in fox2.6a and up - honestly stumped as I remember it did).
Cetin