LIKE Search

[Ruslan Zasukhin]

On 4/9/05 2:27 AM, "Alexey Starchikhin" <ssa at sevenrays.ru> wrote:

> Hello!
> 
> In  V4MD (1)   i  need a LIKE search.   I have a field with multiple ID's
> in format  "|23|45|21|"  e.t.c.
> 
> So i use  "SELECT * FROM Dress WHERE (Type_id LIKE '|23|') "    This works
> perfectly in MS Access,  but in Valentina it  returns ALL records of table.
> Why?

Hi Alexey,

1.x have LIKE keyword, but it do in fact REGEX search.

So you should use syntax of REGEX

    WHERE fld LIKE '\|12\|'

 |  this is control symbol of REGEX, so it should be escaped.


In 2.0 we have LIKE and REGEX commands


-- 
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]