[AccessD] String Manip Help

Drew Wutka DWUTKA at marlow.com
Fri Mar 28 03:59:52 CST 2003


Sounds like you need to use InStr or InStrRev.

something like

Left([MyField],InStr(1,[MyField],"/")-1)



-----Original Message-----
From: William Hindman
To: accessd at databaseadvisors.com
Sent: 3/28/03 2:41 AM
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."


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list