Is there syntax to pass a null value into a MS SQL 2000 database query set up for a parameter value so that the query will disregard the parameter? I've encountered this situation with both ASP 2.0 dataset added to a web site and a VB.net data adapter filling a dataset. With a query using multiple filter criteria using the =@ParamName within the query I hope there is syntax to tell the query to disregard one or more filter criteria not used. Otherwise I'll need a large combination of queries to handle all possible combinations of filter items selected. If yes, I'd love to see a code snippet. Thanks.