>In my table student.sex record is=1,2
>I want to selet records using option button(3 buttion)

select code, sex from student where sex=thisform.option.value&& (1)
>select code, sex from student where sex=thisform.option.value &&(2)
>select code, sex from student where sex=thisform.option.value &&(1) and (2)

>thanks

I am not sure what you asking about.
What is your problem with these SELECTs?