convert "text.00" to "text"

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

For some reason, our data warehouse added .00 to the end
of several text fields in the table I am working with.
When imported to Access, the field is intended to be just
text. So instead of having 12345 for a field in one of the
records, I have 12345.00

I can convert the field type from text to number and set
decimals to 0, then convert back to text. This works.
However, the table is 767,116 rows and memory limitations
choke the conversion.

Is it possible to do this in query? Not all of the records
have the .00, only about 75%. Thank you.
 
You can try an update query.

Update <table>
Set <field> = Replace(<field>, ".00", "", <text compare>)

If you have to restrict the records, apply the appropriate WHERE clause.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top