I have a string such as "4th & Main" that I need to encode into a url. I have looked a urlencode, and Replace using VB and Asp but neither seem to be available in Access 97.

How could I convert 4th & Main to something like 4th %26W Main. Using Microsoft Access 97 code.

Thanks
Brandon