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

>
> If the word:
>
> Alice's
>
> is stored in my database. How do I retrieve it?
>

Use an extra ' as an escape character

select *
from employee
where firstname = 'Alice''s';

(That is two apostrophies not a double quote character)

Adam