[V4RB] [CARBON] Unexpected quit when using LIKE

[Ruslan Zasukhin]

on 3/26/03 4:41 PM, Andy Fuchs at andy at foxwerk.de wrote:

> Update:
> 
> It seems that the db somehow got corrupted! When re-creating the db and
> trying the same thing it worked!
> 
> Although RegEx-grouping seems not to work:
> 
> RegExpressions like '^B' or '^[ABC]' seems to do nothing. Is this expected?

Andy, I think you not correctly understand   ^[ABC]
Should it be [^ABC]

> SELECT Name FROM Person where Name NOT LIKE  'bbe'
> 
> returns Error 609 (Wrong field type)

    what about 
            where Name LIKE NOT 'bbe'

> Best
> 
> Andy
> 
> BTW: Only 20% of my posts come through the list!! :-{

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------