Removing specific characters from a text field

[Guest]

I have a text field of vessel names which need cleaning as some are in the
format "** Vessel Name" or "* Vessel Name". I want to remove the "*"
characters from the field, after which I plan to use the trim function within
a second update query.

I understand that i'd be able to use something like (Replace([Name]"*",""")
to remove them if I was using a later version of Access, but unfortunately my
version is 97 so it doesn't work.

I was trying to use a function containing the ASCII code for the * character
- chr(44), but am unsure how to do this as I couldn't find a specific delete
function.

Any help much appreciated.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "StringStuff.mdb" which has a ReplaceCharacter and
ReplaceString function. There is an Access 97 version available.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L