Lading & Trailing spaces from ODBC table

  • Thread starter Thread starter davespace
  • Start date Start date
D

davespace

I import a couple of tables from a proprietary database
with ODBC. Everything works fine except text fields come
over with leading or trailing spaces for those records
that are not filled. What would be the best method for
removing these spaces? TIA

David
 
Run an Update Query like this:

UPDATE TheTable SET TheField = Trim([TheField]);
 
Back
Top