[dba-SQLServer] Normalizing a text field

Code

At 12:00 PM 5/6/2008, you wrote:
>Date: Tue, 06 May 2008 08:28:19 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Normalizing a text field
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>,         Dba-Sqlserver
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <48204EE3.7030202 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>I have a spreadsheet with a zip column and a column with 0 to many
>cities in the format Name1, St Name2, St Name3, St
>
>Notice that there is no "field delimiter" between St (state) and the
>next city name.
>
>Is there any way in SQL to do this or is this a job for code?  I can
>write the code, but I am lost on doing this in SQL.
>
>--
>John W. Colby