The ID in the replacement has a leading 0
--
Libby


"Sean Timmons" wrote:

What is unique about these ID's? What needs to be changed?

"Libby" wrote:

I have a column of 3600 IDs that I need to find and replace in a table that
has 4 columns and 18000 rows. What kind of a formula that I can create to do
this.
--
Libby