They will be not changed very often. The typical opartaion will be INSERT...

of course on UPDATE I wiill delete the current index records and insert new ones...

What I don't...

As a matter of fact I've seen this article here too some time ago but now I can't find it. 🙂 it is very similar indeed but there...

Hi,

Thank you for your suggestions. There is no other search criteria and the LIKE is two-sided. The search criteria is exactly as I posted it.

The problem is that both solutions...

ALZDBA, thank you for this valuable addition. You are absolutely right.

sg2000, I think you don't need DISTINCT at all. There should be no duplication if you take into consideration ALZDBA's...

I think you can get the result from your example by joining your original UNION query with itself, for example like this:

;WITH Empl(ID, EmplyID, PersonID, Workplace) AS

(

SELECT ...