>I need an example via fox sql, of (if any) pulling the zip-code out of a city,state zip field unfortunately the data has been captured in this one field for years and I need to break it out. There are no constants i.e. (city, state zip), (city state zip), (city-state-zip) or (city, state zip). The zip can be from 5 to 9 numbers in char. Help : )

I'd start at the end and work backwards, maybe like:

cWorkString = ALLTRIM(CityStateZipField)
nLastSpace = RAT(' ',cWorkString)
cZip = SUBST(cWorkString,nLastSpace+1)
cWorkString = ALLTRIM(LEFT(cWorkString,nLastSpace-1))
cState = RIGHT(cWorkString,2)
nLastSpace = nLastSpace - 4  && Drop last space, state is always at least 2 characters
FOR nCtr = nLastSpace TO 1 STEP -1
   IF ISALPHA(SUBST(cWorkString,nCtr,1))
      cState = SUBST(cWorkString,nCtr,1) + cState
   ELSE
      nCtr = nCtr - 1
      EXIT
   ENDIF
ENDFOR
cCity = LEFT(cWorkString, nCtr)