>I am using with set filter command like this.
>

> If thisform.optionbuttion.value=1
>set filter to sex=1
>endif
> If thisform.optionbuttion.value=2
>set filter to sex=2
>endif
> If thisform.optionbuttion.value=3
>set filter to sex=3
>endif

>but now i want to use in sql

You could use the same approach:

DO CASE
   CASE thisform.optionbuttion.value=1
        SELECT ..... WHERE Sex = 1
   CASE thisform.optionbuttion.value=2
        SELECT ..... WHERE Sex = 2
OTHERWISE
        SELECT .....
ENDCASE

That is compilation of Naomi and Sergey's suggestions :-)