I don't want to update with text.

[Abazaba]

Is there a syntax that I can use in my update query that will exclude any text from being updated? I have a field with numbers and text, and I want to update another field with only the numbers. Currently it updates the field with records that contained text to 0s. I want those records to stay blank.

[pbaldy]

How about

UPDATE...
SET...
WHERE IsNumeric(FieldName)

[Abazaba]

That worked! Thank you so much. I'm new to this.

[Abazaba]

Maybe I spoke too soon.

[pbaldy]

Let me know; I would think that would only update records where the specified field had a numeric value, but I didn't test.

[Abazaba]

I'm a complete noob. It worked, and now it doesn't seem to want to work again. This is my SQL if it helps:

[pbaldy]

I don't see anything wrong with that offhand, though I wouldn't bother with the "<>False" part. What do you mean that it won't work again? After it's run once, there shouldn't be anything left to change anyway.

[Abazaba]

It literally did what I wanted, then I tried it again on the same unchanged table and now it proposes no changes.

[pbaldy]

Can you post the db, or a sample that exhibits this behavior?

[Abazaba]

I got it working, thanks for the help!

[pbaldy]

No problem, and welcome to the site by the way!

[Abazaba]

Thanks! I'm sure I'll be back with many more questions. This place looks like a great source of information.