Hi Guys:
I have a big database that i am working on. For this particular part of the project, I would like to repair a bad abbreviation that was used in this section of the database
CommodityID Commodity 5337 Elec eqt 5338 Elec gen systems 5339 elec goods 5340 Elec HH appl: refrig 5341 Elec lamps 5342 Elec lanterns 5343 Elec machy 5344 Elec meters 5345 Elec motor dlr 5346 Elec motor parts 5347 Elec motors 5348 Elec motors fract HP 5349 Elec panels 5350 Elec plating supp dlr 5351 Elec power plt 5352 Elec prod 5353 elec prod mfr 5354 Elec prods plt 5355 Elec prods whse 5356 Elec repairs & distr 5357 Elec resistors 5358 Elec rheostats 5359 Elec solenoids 5360 Elec supp 5361 Elec supp & appl 5362 Elec supp dlr 5363 Elec supp plt 5364 Elec supplies 5365 Elec supplies (distributor) 5366 Elec supplies dlr 5367 Elec switches 5368 Elec transf 5369 Elec transformers 5370 Elec utility 5371 Elec wire 5372 Elec. Appliances 5373 Electr comps 5374 electr prod 5375 Electric Appliances
as you can see the abbreviation ELEC is used in place of Electrical -- Id like to be able to fix this as a batch thing. Is it possible, or do I have to go through and edit each of those by hand?
Thanks
TIM