DRG-50901 and escape characters

From: neo <nelsounet_NO_SPAM__at_free.fr_NO_SPAM>
Date: Fri, 21 Sep 2007 12:34:23 +0200
Message-ID: <46f39e54$0$19258$426a74cc@news.free.fr>

Hi everyone,

I would like to make this work and I don't understand why it throws an DRG-50901 error ( wildcard query expansion resulted in too many terms )

The select is this one :

SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(%)' ) > 0)

The goal is to search "something)*"

the "\" should escape the ")" only..

SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting%)' ) > 0) works fine
and

SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(' ) > 0) works too.

Then What is wrong and how to make this working ?

Thank you for your answer !

Nelson Received on Fri Sep 21 2007 - 05:34:23 CDT