Slightly-OT: SQL Help

[Ruslan Zasukhin]

On 11/8/04 3:24 PM, "Milan" <milan at mook.co.uk> wrote:

> Hi,
> 
> We're just completing a disc done with Director/Valentina. Everything is
> running great, but we've hit a stumbling block with SQL statements. Can
> anyone explain how it is possible to achieve the following with Valentina:
> 
> 1. User searches for: Mary
> 
> 2. This gives results including: St Mary's, Mary Jane etc.
> 
> 3. Search IGNORES a specific word, in this instance PRIMARY.
> 
> 4. BUT.... St Mary's Primary would still be found.
> 
> 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.
> 
> Is this possible? If not, is there a workaround that anybody can suggest?

Please direct your task in more DIRECT words.

* I have these records

* I want to find this

* for this I do next query

* but get this bad results ?



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