[V4MD] LIKE search

[Martin Wright]

Hi

There many instances of the word 'physicians' but not necessarily at the end of a line, simply within the text.

Maybe I should explain what I need to do.

The field I need to search is a text field which is indexed by word.
The user can type in the search term. The search much search for exact matches of the word by default. For example, searching for
'physicians' will find some results, whereas 'physici' should not find any results.

If the user wishes, they can use a wildcard in the search, such as 'physic*', which would return many results.

Is this possible with V1?

Martin


> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 27 April 2006 14:42
> To: valentina at lists.macserve.net
> Subject: Re: [V4MD] LIKE search
> 
> On 4/27/06 4:05 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:
> 
> Hi Martin,
> 
> > Using V1 in Director:
> > 
> > Is there any reson why:
> > "WHERE (content_xml LIKE 'physicians\Z' no_case)"
> > Returns no results but:
> 
> \Z means that word is AT END OF LINE, right ?
> 
> May be you do not have any such word 'physicians' ?
>   
> > "WHERE (content_xml LIKE 'physicians' no_case)"
> > Returns many results of the word 'physicians'.
> > 
> > The content_xml field is a text field and is indexed by word.
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
>