I want to implement full text search for a general database application.  I have a classis cusomer form (Last Name, Address, Phone, etc...) and I
want to make a single search edit box that will search for a field in the DB - Google like.  What is the best approach?  Should I copy and past the
text from each individual fields (Last Name, Address,...)  into a blod / clob field (SearchField) that can use FTS?  

Scott,

<< I want to implement full text search for a general database application.
I have a classis cusomer form (Last Name, Address, Phone, etc...) and I want
to make a single search edit box that will search for a field in the DB -
Google like.  What is the best approach?  Should I copy and past the text
from each individual fields (Last Name, Address,...)  into a blod / clob
field (SearchField) that can use FTS?  >>

No need.  Just create a text index on each desired column, and then search
on them all like this:

SELECT * FROM MyTable
WHERE "Last Name" CONTAINS 'Search Words' OR
"Address" CONTAINS 'Search Words' OR
.....etc.

--
Tim Young
Elevate Software
www.elevatesoft.com