retrieving most recent records along with searching some string

[pradeepht]

hello friends, please help me.

i am using sql-server 7

i have a table called Metadata

columns are slno,title,creator,subject,entrydate ...

slno is primary key.

entrydate contains date and time .

table contains more than 80,000 records.

i want to retrieve most recent records (say within 90 days or 120 days).and

i want to search some strings say 'english' in results of aboue query using

contains ( like contains(*,'english') ) or freetext only.

please help ....how to write queryyyyyyy

[rmiao]

Did you create full text index in the table yet? Ifso, try query like:

select * from Metadata where contains(*,'english') and entrydate > dateadd(dd, -90, getdate())

[pradeepht]

Except entrydate column ,all columns in table are full text indexed but entrydate column is not full text indexed.
and even i tried the query whatever u have given but it is giving 0 records but records that contains word 'english' are their in table but still it is giving 0 resultssssssss.please help me

[rmiao]

Did you chech full index catalog properties? What do you find there?

[pradeepht]

In full text catalog properties,it is showing that table metadata "full text indexing enabled"

[rmiao]

How about word counts and so?