Thanks for the link Markus

Unfortunatley sometimes Dynamic SQL is required and the only way to go.

The document was interesting and has now pointed me to the following document...

Thanks Matt,

I should have thought of that, with a few modifications it worked a treat.

Cheers

Andy

Hi,

Thanks for the link but I cannot see an example of how to help me :- 

take the following query :-

SELECT DICTINCT CompanyID  FROM CompanyCategory WHERE CategoryID IN (49, 107)

This would...

Thanks Tim

I will have a look today at the SQL you provided. I couldn't get 4-Part Name to work, not sure if thats becuase the linked server is Oracle and...

The @Query just contains words that are used to search the full text engine, for example :-

'Machining NEAR Centres'

Also the @FirstTerm, would be the first word of @Query, so in...

Hi

I have created a stored procedure based on the advice given earlier, I have change dthe sql to now return all the fields I require, however there are some performance...

Thanks David

I can see exactly where I was going wrong now 🙂

Thanks

Andy

Thank you for your reply, I thought it was not possible, worth a try though 🙂

I managed to get the results I required using weights and rank.

Thanks

Andy

Jesper,

Thanks for the quick response, that has solved my problem for now, but I would also like to know if it can be done without a function.  I had got...

Thanks, the distinct in the count works for me.  Simple but effective 🙂