Editing a field in a database

[Jarrett311]

I have a field called Address (which contains a person's street address). Then I have 2 fields (StreetNUM & Street). I was able to pull out the street numbers in the address field and put it into to the StreetNUM field. How do I fill the Street field with everything after the street number in the address field?

Sorry if it is confusing.

Thanks,

Jarrett

 

[DSummZZZ]

Try using something like:
SUBSTR(AT(' ', street))


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm