What do you mean it didn't work? VFP uses fixed length fields, meaning that if you specify a length of 50, you'll always get 50 characters, with spaces at the right.
>I have a table that has been given to me to strip data into seperate fields
>The table has one field that contains city,state and zip in one field and I need to seperate them into seperate fields. Normally I sue case statements an search for blank between the data, but ths has become tedious and ineffective. The reason being mostly is that the data normally looks something like this: 'Upper Saddle River NJ 07458' with many trailing spaces to the right of the string. I tried RTRIM function Replace all citystatezip with RTRIM(CITYSTATEZIP) but that did not eliminate the trailing spaces.
>
>Is there an easier way to parse out this data???
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer