free text search

does anyone have code that shows how to separate individual words from a sentence.

e.g. i have a list of questions and answers in my database and have the following query for it:

SELECT question, Answer
FROM QuestionsAnswer
WHERE FREETEXT(Question, 'i want to travel around the world and learn about cooking')

so i want to extend the above query so that takes each key word (travel, cooking, learn) to find out how frequently that particular word appears in the question (for ranking purposes).

I know freetexttable does rank results, but they don't seem accurate enough for what i need to do.

HELP!!!i've just been told that freetext does this anyways...

=D|||have u tried search on the web|||You will need:

* A one column list (table) with all unimportant words. For that purpose I used a 20-year-old Commodore 64 text adventure interpreter list.

* A two column list (table) with the important words and the number of total occurences for each word.

You parse your text with space, comma, etc as word seperators and run each word against the first list. If it is not their you search it in the second list. If it is their you increment the occurence counter. If it is not their you add it with an occurence counter=1.

Check your second list from time to time in order to see if you can transfer a word from list 2 to list 1.

Easy, isn't it ?

FREE SOFTWARE!

DB Ghost - the scripter, scripts out all your database objects as individual scripts. This includes static data, so you can select your static data tables and "the scripter" will create a .SQL file containing all the insert statements for that table. Each
different object type will be created within it's own directory. DB Ghost - the scriptor can then add all these files into Visual SourceSafe mirroring the structure on your hard-drive as Directory to Project and source file to SourceSafe item.
So there you have it, a quick and painless way to script and save all your SQL Server database code into SourceSafe - just point and click.
Best of all though - it's free, just download the DB Ghost evaluation version (which is limited to thirty days) and DB Ghost - the scripter is included which never expires!
www.dbghost.com
Mark, spammers often use subjects such as yours within their posts. I =
almost did not open your post, but then I read your name and I figured =
that this message had a 95% chance of being legit so I took the chance =
and opened the post. You may want to submit another post that mentions =
your product in the subject line.
--=20
Keith
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message =
news:B32097DF-10D3-4D4C-8C5C-965A46178E3D@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as =
individual scripts. This includes static data, so you can select your =
static data tables and "the scripter" will create a .SQL file containing =
all the insert statements for that table. Each different object type =
will be created within it's own directory. DB Ghost - the scriptor can =
then add all these files into Visual SourceSafe mirroring the structure =
on your hard-drive as Directory to Project and source file to SourceSafe =
item.
>=20
> So there you have it, a quick and painless way to script and save all =
your SQL Server database code into SourceSafe - just point and click.
>=20
> Best of all though - it's free, just download the DB Ghost evaluation =
version (which is limited to thirty days) and DB Ghost - the scripter is =
included which never expires!=20
>=20
> www.dbghost.com
>
|||thanks Keith, I'll follow your advice

Free database tool ~ DB Ghost - the scripter

DB Ghost - the scripter, scripts out all your database objects as individual scripts. This includes static data, so you can select your static data tables and "the scripter" will create a .SQL file containing all the insert statements for that table. Each
different object type will be created within it's own directory. DB Ghost - the scriptor can then add all these files into Visual SourceSafe mirroring the structure on your hard-drive as Directory to Project and source file to SourceSafe item.
So there you have it, a quick and painless way to script and save all your SQL Server database code into SourceSafe - just point and click.
Best of all though - it's free, just download the DB Ghost evaluation version (which is limited to thirty days) and DB Ghost - the scripter is included which never expires!
www.dbghost.com
But its not really free is it. Its a trial version of your software.
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message
news:87390168-7861-4238-AB47-CDB3A281492F@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as
individual scripts. This includes static data, so you can select your static
data tables and "the scripter" will create a .SQL file containing all the
insert statements for that table. Each different object type will be created
within it's own directory. DB Ghost - the scriptor can then add all these
files into Visual SourceSafe mirroring the structure on your hard-drive as
Directory to Project and source file to SourceSafe item.
> So there you have it, a quick and painless way to script and save all your
SQL Server database code into SourceSafe - just point and click.
> Best of all though - it's free, just download the DB Ghost evaluation
version (which is limited to thirty days) and DB Ghost - the scripter is
included which never expires!
> www.dbghost.com
>
|||No Brian,
"DB Ghost - the scripter" really is free, no evaluation period, no cost - Free!
"DB Ghost" has an evaluation period and has a cost - "DB Ghost" is not free.
Two seperate exe's, doing different things, one which is free, one which is not.
Same MSI, two exe's. Download the DB Ghost evaluation and it'll come with the scripter which is free.
-- Bryan Oliver wrote: --
But its not really free is it. Its a trial version of your software.
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message
news:87390168-7861-4238-AB47-CDB3A281492F@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as
individual scripts. This includes static data, so you can select your static
data tables and "the scripter" will create a .SQL file containing all the
insert statements for that table. Each different object type will be created
within it's own directory. DB Ghost - the scriptor can then add all these
files into Visual SourceSafe mirroring the structure on your hard-drive as
Directory to Project and source file to SourceSafe item.[vbcol=seagreen]
SQL Server database code into SourceSafe - just point and click.[vbcol=seagreen]
version (which is limited to thirty days) and DB Ghost - the scripter is
included which never expires![vbcol=seagreen]