Hi,
Have a table designed as follows

equip1          text
equip2          text
equip3          text
equip4          text
equip5          text
equip6          text
equip7          text
equip8          text
equip9          text
equip10          text

What I need to do is to check each field and if the field is =
"Tennessee" then
update it to read "TN"

Is there a way to do this in one update query vs having to write 10
different update queries?

Thanks