[AccessD] String Manip Help

Warning: Late at night AND OTTMH! :D

SELECT CSZ: Left(YourField,Left(YourField,Instr(1,YourField,"/")-1),
	 Country: Right(YourField,(Len(YourField) - Instr(1,YourField,"/")))
FROM SomeTable

HTH
David McAfee

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William
Hindman
Sent: Friday, March 28, 2003 12:41 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] String Manip Help


...record field in table has a data string formatted like "city, state, zip
/country" (without quotes)
...need to run an update query to remove the " /country" from each record
where "country" can be any length
...any ideas appreciated :)

William Hindman
"You know the world is going crazy when the best rapper is a white guy, the
best golfer is a black guy, The Swiss hold the America's Cup, France is
accusing the US of arrogance, and Germany doesn't want to go to war."