A few questions re Valentina compared with SQLite

[bigbird]

Hi Ruslan,

Just to clarify, I have a column that could contain the following  
dummy text records:

	1	The man had a HAT.
	2	The HAT was on his head.
	3	HAT day at the school was a great success.
	4	We all saw tHAT the beach was crowded.
	5	He was as mad as a HATter.
	6	He did not know wHAT he was talking about.
	7	HATs are very popular this year.

If the user types 'HAT' into the search field, I would like to return  
records 1, 2 and 3 but NOT records 4, 5, or 6.

There will never be just a single word in the column, so '= hat'  
won't work (as far as I know) - the column may contain well over a  
hundred words.

Ideally, also I would like to be able to return simple 'plurals' like  
record 7 when 'HAT' was the word searched for.

I would also like to offer an option to the user that would find HAT  
on its own OR embedded in another word like wHAT if they chose to do  
so (SQLite ONLY offers this choice, as far as I can see).

> IndexbyWords build special index that keep separate WORDS.
>     then search as  WHERE fld = 'hat'  should find EXACT matches


Cheers

Greg Olson-Hyde

Sydney Australia

RB 2007r5 Pro, Mac OS X 10.4.11