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

>
> --- 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
>

I tried the two apostrophes, but didn't get any records.

My data looks like this: Alice's
My SQL looks like this: SELECT * FROM CONTACTS WHERE COMPANY = 'Alice''s'

What am I missing?