> Replace(your_db_column_name, "&", "&", "ALL") Good solution, but don't forget that if you have any encoded values in the database like < then they'll end up as &lt; (which, of course, will kill all the encoded characters). Regards Mark Howells <http://www.mark.ac/> AIM: mhoaim