I have a data back that I need to mass copy data from one field to another. This is a description field only and will not disrupt the function of the database. I know what I want but don't know the scripting language. What I need in lamans terms is as follows.
IF (FIELD1 = "BOT") THEN REPLACE (FIELD2) WITH (FIELD3)