What does it bring back?

A syntax error or just no results?

Does it work fast on substequent searhces if you use different queries?

A J,

Try specifying the format for the date in your convert statement and try casting to a specific type e.g.

SELECT col_names

FROM tablename

WHERE

CAST(T_DATE as DATETIME) < CONVERT(datetime,dateadd(d,7, getdate()),103)

Also make sure that...

Do you have a population schedule in place? Could this be interfering with the population of the catalogue and hence slowing down your search?

I can't see any options for the...

LXZ20 and Amit,

Are you saying this doesn't work?

FROM ColumnName

WHERE CONTAINS(FulltextCatelogueName, '"*men*"')

This is my code exactly I've just taken from a project which is verified to work:

SELECT DISTINCT Res.RANK AS RANK, ...

Sorry, just trying to help, i have it all coded somewhere but was working from memory to give you pointers. I would have looked it up for you if you...

No problem,

Try putting a wild card in so it becomes:

SELECT ColumnName

FROM ColumnName

WHERE CONTAINS(FulltextCatelogueName, '%men%')

Hope that helps.

Ed

Mark,

Can you elaborate on a 'good salary'? Are / What any additonal benefits?

Will you consider remote workers?

Ed

Amit,

I'm assumung you've already created a full text catelogue for this table?

If you have you just need to run a query like this one:

SELECT ColumnName

FROM ColumnName

WHERE CONTAINS(FulltextCatelogueName, 'men')

Hope this helps

Ed

I just found this out myself yesterday, pitty it was 3 days after I set-up all my databases manually...always the way!

Hi Joseph,

Thanks for the reply and here goes a little more info.

Every once in a while (could be every few days, every day or once a year) I would like...

Glad to have helped.

That query looks fine to me, if it works, it works.

I generally tend to use NEAR as with bigger data sets if cuts the wheat from the...

Dan,

Yes you need to use a RANK clause and can I suggest maybe using a NEAR boolean opperator instead of OR or AND as it will bring back results with...

Yes you can install the full text searching service.

Try

Put in the SQL Server CD, run the auto install, go through the normal install route and just tick the Fulltext search...