Thank you very much, I got tied up this afternoon but will give it a shot in the morning and let you know how it goes.

This might end up being a double post, the first one didn't seem to show up so posting again for good measure.

is it possible that more than one number appears...

is it possible that more than one number appears int eh memo field? ie two or three 1/17 digit numbers?

Yes

is it possible that the search for numbers are formatted, like...

Our call logging software has it listed as "Memo" but ultimately it is a text field.

I have account numbers within text fields in a table that need to be replaced with X's for security purposes. The account numbers aren't always in the same position...

Thank you very much, worked perfectly.

Sincerely,

The Noob

I have full access to the server, however I'm not that well versed in SQL. Creating a job would work just fine for what I'm looking to do, however...