LIKE Search

[Alexey Starchikhin]

Thanks,  everything is  ok  now.   This project is about to complete,  so
it's too dangerous for me to switch it to V2 now.  I'll  do this for the
next one. :)

Alexey

----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Saturday, April 09, 2005 11:39 AM
Subject: Re: LIKE Search


> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>