Null Parameter

how does the isnull parameter work? I am at my wits end trying to get this to
work
I have a list (Male & Female) drop down based on another dataset. I have
included ALL in this list. I want to be able return results from both gender
when the ALL is selected from the drop down.
I need help on how i can do this : by expression or by anyother means.SELECT * From MyTable WHERE Gender=@.Gender OR @.Gender = 'All'
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bibo" <bibo@.discussions.microsoft.com> wrote in message
news:7B3FBF72-27E0-492F-B34B-0C092D97FBD5@.microsoft.com...
> how does the isnull parameter work? I am at my wits end trying to get this
> to
> work
> I have a list (Male & Female) drop down based on another dataset. I have
> included ALL in this list. I want to be able return results from both
> gender
> when the ALL is selected from the drop down.
> I need help on how i can do this : by expression or by anyother means.