tnx for the reply, some more questions please:

1...Is it possible to get 3 as a final result....ie the total number of different combinations?

2...why did you comment out the pipe separator (|)?

3...Is it possible to achieve the same result without using FOR XML path, because this is kind of slow.

tnx