General information
Forum:
Microsoft SQL Server
Title:
HT Ltrim using query
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
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