(no subject)

[william humphrey]

Are you using a search like:

SELECT * FROM table_name WHERE search_word LIKE  '%hat'


this would eliminate "hatter"


you can also do 'hat'


Use SQLitemanager to experiment with your SQL



-- Then use Valentina Studio with the same database and SQL searches and
compare the time it takes.




On Sat, Apr 19, 2008 at 8:45 AM, bigbird <greg at hawkmount.com> wrote:

> Hi,
>
> I am currently using RB 2007r5 and the built in SQLite db - I have struck
> a problem and need to know if Valentina is a solution.
>
> The things I need to know about Valentina are:
>
>        1. I have a db with 50,000 records - I need to search and find,
> say, the word 'HAT' SQLite also finds 'tHAT', 'wHAT' and 'HATter'
>
>
>
> Cheers
>
> Greg Olson-Hyde
> Sydney Australia
>
> RB 2007r5 Pro, Mac OS X 10.4.11
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com