--- In firebird-support@yahoogroups.com, "ion5w" <ion5w@...> wrote:

>
> How do I search a VARCHAR field for data that has either single or
> double quotes?
>

Use a second quote to escape it for a single quote. A double quote
should work like any other character.

select *
from employee
where LastName = 'O''Conner'

select *
from employee
where LastName = '"Hello World"'

Adam