Haha, thks again.

It worked great. I had tried to post in many forum but you are the only one who can managed to solve it. Great thks.

U are really helpful and i greatly appreciated it. But encounter the following error:

Invalid object name 'dbo.Tally'

Thks.

I am not familiar with binary. Pls help me out when you are free. Thks

Yes. The width of each element is always 2.

The maximum number of elements will be 10. And each element is unique. And the pass in string maybe not be in order e.g: "01-02-04-03", "03-02-01".

For example string "01-02-03-04" will return 11 rows:

1. 01 - 02 - 03 - 04

2. 02 - 03 - 04

3. 01 - 03 - 04

4. 01 - 02 -...

Thks for the fast response. But your query return 340 rows instead of 11 rows. Pls also take note that i may be able to pass in "01-02-03-04-05".

Thks. Thats working. But why you need to use like "%", "^", "*" in the query? And its also work i i pass in the punctuation.