Thanks for the reply. By using a temp table I have solved the problem.

But whats the difference between Declare & Create :

DECLARE @NewTable TABLE (...) AND

create table #temp(...)

'Create Table...' in...

I have designed my table using :

ShortDescription Nvarchar (1000)

LongDescription Nvarchar (3000)

I can change my table structure if YOU gurantee that I will not get into size restrictions

Thanks Kenneth

I have copied the code as you provided it, and yes it works.

I will be adopting the code to my Tables

Just another question:

How does replacing a space with %, make it...

Kenneth, I just tried it, but I get errors:

Incorrect syntax near the keyword 'LIKE'.

Thanks KH

But the problem is that I will not know how many keywords there will be. A user may enter 'monitors' or 'monitors sensors' or 'monitors sensors LCD'

So I would...