Hello again John,

I see what you you mean now about the results.

The odd thing about the code is that the first line of that section;

 set @sql = @sql + '...

Hi John,  thank you for your reply.  I think from what you say that simple pattern matching rather than full-text indexing should suffice.  The stored procedure is to take search...