Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HT Ltrim using query
Message
From
29/05/2001 00:42:00
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
HT Ltrim using query
Miscellaneous
Thread ID:
00512063
Message ID:
00512063
Views:
38
I'm trying to trim all of the trailing spaces from data in a query when it is imported into SQL 7 using the DTS Import service. 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
Next
Reply
Map
View

Click here to load this message in the networking platform