This question already has an answer here:
We've recently started working with ArcMap, having used MapInfo previously. I've created a shapefile in ArcCatalog and want to update some columns using SQL. In MapInfo I'd write the following command in the MapBasic window.
UPDATE Clearance SET GTID = "GT" & FID
I can't find where to do this in ArcMap - any pointers?