Valentina Question - 'like' and \a \z

[Ruslan Zasukhin]

On 10/3/06 4:02 AM, "Dave Miller" <dwmiller at umich.edu> wrote:

Hi Dave,

If you want to use REGEX syntax, which in 1.x was as LIKE,

In v2 you need to use
    WHERE fld REGEX '\AApparel Boys\Z'


LIKE now use SQL92 syntax


> I have an older Director Appliction I'm updating to use Valentina 2.
> Have the \A and \Z markers been tossed? Is there a replacement?
> 
> This is returning an empty set when it shouldn't.
> 
> SELECT  sort1, sort2, sort3, sku, style, colorCode, dateAvailable,
> colorGroup, silhouette, USAbase
> FROM protable
> WHERE (
> (sort1 LIKE 'Apparel Boys'
> AND
> sort2 LIKE 'Boys Basketball'
> AND
> sort3 LIKE '4/1')
> )
> AND
> ( sort1 LIKE '\AApparel Boys\Z')

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