I need to query an Access 2000 text field from an ASP VB script. The field has certain characters that need to be (temporarily) ignored during matching. Those unwanted characters may appear anywhere in the field.<BR><BR>Access doesn't seem to like the following:<BR><BR>SELECT * FROM Table<BR>WHERE Replace(TextField,"X","") = 'RequestedText'<BR><BR>Any suggestions? I imagine this is a common question but have searched fruitlessly. Thanks.