[V4MD] IN or LIKE?

Martin Wright martin at kinetix.co.uk
Mon Mar 20 18:58:58 CST 2006


OK thanks.

Another thing, does 'no_case' not work in V2?
Is there another way of doing a none-case-sensitive search?

Martin


> 
> On 3/20/06 8:23 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:
> 
> >> Is there any reason why
> >> 
> >> WHERE ('derma' IN ('tbl_subsections.content_xml'))
> >> 
> >> Doesn't find any results but:
> >> 
> >> WHERE (tbl_subsections.content_xml LIKE '%derma%')
> >> 
> >> Does find results?
> > 
> > We are talking about v2 ?
> >>> YES V2.
> 
> Because 
> 
>     WHERE ('derma' IN ('tbl_subsections.content_xml'))
> 
> Search for EXACT match
> 
> 
> --
> 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-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
> 
> 





More information about the Valentina-studio mailing list