AnsweredAssumed Answered

Add a leading character to a string

Question asked by edwac080@newschool.edu on Nov 23, 2014
Latest reply on Nov 23, 2014 by edwac080@newschool.edu

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.)

Outcomes