[V4MD] LIKE search

[Ruslan Zasukhin]

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]