Select strings with "(" inside

[Carsten Ilwig]

Hi,
thanks for your answer, it works very fine.

Best regards to Belgique
Carsten

----- Original Message ----- 
From: "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Thursday, June 19, 2003 5:59 PM
Subject: Re: Select strings with "(" inside


le 19-06-03 15:45, Carsten Ilwig <Carsten.Ilwig at portal-rind.de> a écrit :

> Hi all,
> how can I find strings which are include this chars '(' + ')'?
> If I use the following syntax I get return nothing:
>
> select FieldName from basobject where KeyWord like '\AEnergie (ME)\Z'
no_case

You must escape the parenthesis

  SELECT FieldName FROM basobject
   WHERE KeyWord LIKE '\AEnergie \(ME\)\Z' no_case

... unless you want to use the regex features.

Note that other chars need this too :
     )(?'.+*
because they are used by regex.

François Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina