[AccessD] String Manip Help

William Hindman wdhindman at bellsouth.net
Fri Mar 28 02:41:00 CST 2003


...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."




More information about the AccessD mailing list