dkim18
asked on
a way to filter using parameters including nul/blanket records?
I am using a paramter to query the table. ProjectTable(id,status,tea m).
Select * From projectable where team in (@team)
OK this is fine but I also would to include null and blanket value when I select all teams from the parameters.
How can I do that?
Select * From projectable where team in (@team)
OK this is fine but I also would to include null and blanket value when I select all teams from the parameters.
How can I do that?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER