[AccessD] Normalizing a text field

...if I really wanted to do this without code, I'd just ditch the St part 
and fill the State field with a look-up from the zip.

William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Tuesday, May 06, 2008 8:28 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>; "Dba-Sqlserver" 
<dba-sqlserver at databaseadvisors.com>
Subject: [AccessD] Normalizing a text field

> 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
> www.ColbyConsulting.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>