[V4RB2] SQL REGEX Help

[Ruslan Zasukhin]

On 6/29/05 7:19 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

>>     indexes, searches, sorting, LIKE -- take care on collation
>>     regex -- no
> 
> wow, I feel confused now...
> 
> What are the differences between a LIKE and a REGEX search?
> 
> I thought that the LIKE keyword was deprecated in v2...

No, visa versa. In 2.0 LIKE work by SQL92 standard, using  % and _
In 1.x LIKE did work as REGEX.

So to have regex in 2.0 we have to use new keyword

    WHERE fld REGEX ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]