search with apostrophe

[Frank Schima]

Hi Roger,


On Mar 17, 2005, at 6:36 AM, Roger Amar wrote:

> When I search for a phrase with an apostrophe, Valentina XCMD cannot
> find it.
> Yet, I use "English" as language for the field.
> What is wrong ?

What is the SQL you are using? Are you escaping the apostrophe?

This works for me:
    SELECT myField FROM myTable where myField like '\''


Best regards,
Frank Schima