case-insensitive searches

Charles Yeomans yeomans at desuetude.com
Tue Jun 28 18:52:33 CDT 2005


I've got a text field that is indexed by words.  In V4Rb 1, to do a 
case-insensitive search I needed to define a method field and search 
it.  Is this still the case in V4Rb 2, or can I now do something like

SELECT textField from ATable WHERE Lower(textField)="foo" ?


--------------
Charles Yeomans



More information about the Valentina mailing list