[NEW][SQL] fld NOT LIKE, fld NOT BETWEEN, fld NOT IN

[Ruslan Zasukhin]

Hi guys,

I have polish the NOT operator.

1) now resolved old issue with "fld NOT LIKE s"
    If you remember before this did not work,
    and was need to use "NOT fld LIKE s"
    which is kind of "NOT expr" rule.

    now "fld NOT LIKE s" works correctly.


2) works the following syntax constructions:

    WHERE fld NOT BETWEEN a AND b
    WHERE NOT fld BETWEEN a AND b
    
    WHERE fld NOT IN (a,b,c)
    WHERE NOT fld IN (a,b,c)

    WHERE fld NOT IN (SELECT ...)
    WHERE NOT fld IN (SELECT ...)


-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------