>I'm trying to trim all of the trailing spaces from data while using a query as the datasource for data imported into SQL 7. However, when I use the expression ltrim(`cust`.`fieldname`), the data is imported with trailing spaces intact. The weird thing is that there are no trailing spaces in the original VFP data. What is happening here? TIA
Rixon,
don't you mean RTRIM?? LTRIM will remove LEADING spaces! Nonetheless, in MS-SQL if you import "ABCDE" into a char(10) field, and then read that back in VFP into a cursor, you will get back "ABCDE " in the cursor's field. This is because the VFP cursor will be defined to char(10) and in VFP fields are always right space-padded to the field length.
-Arne
arne@synercom-edi.com "There are no absolutes but this one."
President, synercom/edi - Event Ticketing Solutions