[VSKD] how to simulate WHERE left(field) = 'word'

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Apr 7 17:58:45 CDT 2003


on 4/7/03 5:02 PM, Antoine Beyeler at globule at vtx.ch wrote:

> Hi there,
> 
> 
> 
> Using BitSet and VDK_Field (a subclasses) method, is it possible to
> reproduce the behavior of "WHERE left(field) = 'word'", that is an
> indexed search on the _beginning_ of the field content? If yes, how?

Very simple.

Just do   

    f.find( true, "word", "word\x255", false );

I.e. Ranged search from 'word' to infinity.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list