hello;
 Stats: V 4.25 Build 7

Problem r as the Project managers say "an Opportunity")
I need to remove all of the occurrences in 1 field with the values from
another field as in  this failed attempt

UPDATE vendors_20080207
SET [Street Name1] = REPLACE ([POBox] WITH '' IN [Street Name1])
WHERE [Street Name1] LIKE %[POBox]%;

TIA

aLLAN

Allan,

<< Problem r as the Project managers say "an Opportunity") I need to
remove all of the occurrences in 1 field with the values from  another field
as in  this failed attempt >>

Roy's answer is right-on.  Make those replacements and you should be all
set.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks to you both.
my head is spinning at the data I have to clean up here



Allan

Tim Young [Elevate Software] wrote:
> Allan,
>
> << Problem r as the Project managers say "an Opportunity") I need to
> remove all of the occurrences in 1 field with the values from  another field
> as in  this failed attempt >>
>
> Roy's answer is right-on.  Make those replacements and you should be all
> set.
>