storing a lsit of checkbox | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

storing a lsit of checkbox

what is the most correct way to store a checkboxe’s that were selected,and save them by there id value for example.
and if i want to make a search for example if a user have choosen : 1,5,9,32
and i want to search who has choosen 1 and 9 i will get the relevent user
thnaks in advance
Hi,<br />didn’t understand your question , would you re-form it !<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Post some sample data and the result you want Madhivanan Failing to plan is Planning to fail
ok say for example i have a form with 3 question
each question has a checkbox likethis :
[checkbox] blue
[checkbox] red
[checkbox] green
and i ask the user to mark his favorite color!
and he checks blue and red.
now there values are 1 and 3
and i want to store them in the DB and when needed to make a search for example on :
"who love the colors blue OR red"
and my user will be picked beacuse he likes blue.
so what the most correct way to store this detailes?
thanks in advance