If there are no digits in the city and state name than

lcStr = "Wayne, NJ 07470"
? PADR(CHRTRAN( lcStr, CHRTRAN( lcStr, "0123456789", ""), ""),9)
* otherwise
? PADR( SUBSTR(ALLTRIM(lcStr), RAT(SPACE(1), ALLTRIM(lcStr))+1) ,9)

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