Delete Partial String HELP!!

[Crawfordrider33]

I have a column in my databse that has random numbers. There are some numbers in the database that have .0 at the end of them. For example: 44551.0. I want to create an update query that will delete the .0 from the values.



Thank you!

[JoeM]

So, is it safe to assume that the column is formatted as String, and not any Numeric format (if it was just special numeric, they would all be formatted the same way)?
Will they always end in ".0", or could it be other things like ".9"?
And could there be more than one number after the decimal point (i.e ".12")?
If they are long numbers, do they have any thousands separators (i.e. "123,456,789.0") or any other non-numeric characters in them?

[June7]

This is a text field? The length of the strings is variable? Is this a one-time event?

Why don't you just do a manual Find/Replace?

Otherwise try:

UPDATE tablename SET [fieldname]=Trim(Val([fieldname]))