Pattern matching

[Dale Seaburg <kg5lt(at)verizon(dot)net>]

I have an sql question.  I need to be able to search for text which  
may have buried single-quotes.  I need to be able to effectively  
ignore the single-quote in the WHERE clause.  Here is an example of  
what a user might be looking for, but the data may have an embedded  
single-quote:

PARKS PLACE ADDN

But, the data field may contain one of the two following entries,  
both legitimate:

PARKS PLACE ADDN
PARK'S PLACE ADDN

What would be the best way to structure the WHERE clause to  
effectively capture both types of records?

The more general question would be, "How to structure a query to  
ignore certain characters?"

Regards,

Dale Seaburg