Long story short, I'm trying to get County FIPS data to match from one table to the next.
One table has a string field with 3 character county FIPS codes, the other table has a longer codes where a number corresponding to each state precedes the 3 digit county code. For instance, Autauga County, Alabama is 1001 in one database but 001 in the other.
How would I go about adding a leading character to the string 001? (I figure part of the solution is to select each state and then run the field calculator on each selection, but flummoxed on how to form the expression.)