I understand how and why to strip apostrophes in your ASP whenever you need to pass it to a SQL statement. There's tons of documentation on stripping it from your Form variables and placing the new string with the two apostrophes eg:"''" into the database. Then when calling it back up for display on a web page how you do the opposite and Replace(rs("myField"), "''", "'") so it looks normal again. This is great when I'm the one controlling the data that's submitted into the Database from my web page. But my problem is with a straight query against fields that may or may not contain an apostrophe. Like trying to match someone searching for say "O'Brien", and actually finding "O'Brien". When I try to do the replace apostrophe function directly against the required field from the database inside the SQL statement, I get errors. But because I am relegated to only taking the apostrophe out of the Form's submission, and trying to pass that along as the search criteria, I don't get a proper match. Like O'Brien = O'Brien becomes O Brien <> O'Brien or O''Brien <> O'Brien, which basically gives me nothing. <BR><BR>I've never seen any documentation on how to get around this. Does anyone out there have a solution. Thanks.