query with parenthesis

[Ruslan Zasukhin]

On 10/8/04 12:40 AM, "Gregory Kowalski" <gregkowalski at earthlink.net> wrote:

> Hello,
> 
> I am having trouble making queries for strings that contain parentheses.

You need escape such string, because () are used in the REGEX syntax

 
> I have a field called "form" that, among others,  contains the
> following string:
> 
> Purified F(ab')2
> 
> When I make a query using the expression:
> 
> keyword = "Purified F(ab')2"
> 
> "select * from TABLE where form = '"&keyword&"' "
> 
> I get no results.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------