Get rid of zeroes in a table

  • Thread starter Thread starter www.ttdown.com
  • Start date Start date
W

www.ttdown.com

I have a table that is imported from a .csv file. One of the fields
is a numeric field and holds the numbers 0-9. I'd like to write a
query that would get rid of all the 0's and leave the fields that
contained the 0's empty without disturbing the fields that contain the
numbers 1-9. Can anyone help?

Thanks!
 
Back
Top