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???