[AccessD] Normalizing a text field

Well, actually there is a delimiter, a space, it just isn't reliable
because there can be spaces in both the city name and the state name as
well.  

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 06, 2008 5: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