Re: How to escape double quote in SQL term?

[Jukka Zitting]

Hi,

On 6/8/07, gsoap <[EMAIL PROTECTED]> wrote:

How can I escape double quote in my following query, following attempt gives
error?

SELECT * FROM nt:base WHERE CONTAINS(., '"This term contains \" double
quote."')

You can use "" for that. Like this:

SELECT * FROM nt:base WHERE CONTAINS(., '"This term contains "" double quote."')

BR,

Jukka Zitting