Your idea seems good. I have tried, and only the first row of my table is being updated. ??

Im actually programming in asp.net. So if my user bets on 8 numbers, i actually need to do 8 Insert Statements??

Is this right? Instead of a Single Insert Statement...

I also need to calcuate the number of BetIDs which has the winning numbers? How do i do that??

Btw, for my Bet Numbers I can actually have some numbers...

Ok, I have some changes...I do not quite get what u are saying for the change in table.

Table has BetID, Bet_Numbers 1 to 8.

Now I want to query my Table...

Could you show me in SQL. Thanks

I forgot to Mention. That If I use all that condition, that means I need to get 5 matching numbers.

But what if i have 3 matching numbers?

How can i have...

I will give it a try.

Then how about copy that Matching record into another Table?

Thanks it worked...