Select strings with "(" inside

[Francois Van Lerberghe]

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