Escaping for regex search

[Francois Van Lerberghe]

Hi Beatrix,

This seems to work well here.
The correct search string must be :
    myTableName.myFieldName REGEX '(?i)\\+'

With RealStudio, I write this as

    dim s As String
    s = "+"

    mySQL = ... + " REGEX '" + Valentina.EscapeString("(?i)" + s) + "'"

Cheers.

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


le 28/05/12 10:56, Beatrix Willius <bwillius at gmx.de> a écrit :

> Try a search with a + in the regex search like REGEX '(?i)+' )