adding some data, and removing some to one field in an update query

  • Thread starter Thread starter alexn via AccessMonster.com
  • Start date Start date
A

alexn via AccessMonster.com

I want to remove a bit of data from some records, say the ones that start
with BIG (like BIG Apple, BIG House, etc) remove the BIG, and replace it with
RED. I get how to add the RED part in ( using Update to: RED&[Name]

is it possible to do both, in the same update query?
 
thanks Allen, that helps

Allen said:
To replace BIG with RED anywhere it appears in the field, use the Replace()
function in the Update query:
Replace([Fiedl1], "BIG", "RED")

If you run into problems with that in Access 2000, see:
http://support.microsoft.com/?id=225956
I want to remove a bit of data from some records, say the ones that start
with BIG (like BIG Apple, BIG House, etc) remove the BIG, and replace it
with
RED. I get how to add the RED part in ( using Update to: RED&[Name]

is it possible to do both, in the same update query?
Click to expand...
Click to expand...
 
Back
Top