Have to import fixed width fields from old FoxPro. All field data must be trimmed. Lots of tables and many fields. Tried trim() in update query but it quit when it found a few records with actual spaces and nothing else. I guess you can't trim if there is nothing to trim against. Anyway can find...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.