Slightly-OT: SQL Help

[Ruslan Zasukhin]

On 11/9/04 9:16 AM, "Peter Lindgren" <Peter.Lindgren at fdt.se> wrote:

> Hej!
> 
>> On 11/8/04 3:24 PM, "Milan" <milan at mook.co.uk> wrote:
>>> How can this be achieved? The NOT LIKE command cannot be used, as we
>>> want to include instances where MARY and PRIMARY exist together
>>> (RoseMARY, for example). The word PRIMARY needs to be completely
>>> disregarded when the search is performed.
> 
> I don't know if Valentina supports this syntax, but you should be able to
> write something like SELECT name FROM yourtable WHERE name LIKE '%mary%' AND
> name<>'PRIMARY'

Valentina 1.x consider LIKE as REGEX so should be then

    WHERE name LIKE 'mary'

> If you have many exceptions, put them in a table:
> SELECT ... WHERE ... AND name NOT IN (SELECT exception FROM
> tablewithexceptions)

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