select * from person where email = :email

if the email address is a@... then it is fine, but if the email contains an apostrophe a'oneill@b,com then it fails to locate the record. Even if I use a string replace rather than a parameter it fails.

In FlameRobin 

select * from person where email = 'a''oneill@...'

is fine.

any ideas?