[AccessD] Normalizing a text field

I think that "0 to many" part means it's going to have to be a code
solution.

Just MHO.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 06, 2008 8:28 AM
To: Access Developers discussion and problem solving; Dba-Sqlserver
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