我想你可以用isnull和这样的条件-
假设输入参数是inpgen、inpsub和inpage。

SELECT ...
FROM table 
WHERE
(inpgen is null OR inpgen in ('Male','Female'))
AND (inpsub is null OR inpsub in ('Bellville', 'Durbanville', 'Brackenfell'))
AND ( inpage  is null OR inpage between 5 and 17)

所以，当用户只选择age时，其他两个条件将为null，并返回所有值。在我们的一个工具中，它需要考虑inpgen=''，而不是null。

作为将来的参考，一个通用的解决方案

Declare @inpgen varchar(100) = 'Female'; Declare @inpsub varchar(100) = 'Mohali'; Declare @inpage int = 23;

SELECT *
FROM Tutor t 
Where 
    (@inpgen is null OR t.Gender = @inpgen)      
    AND
    (@inpsub is null OR t.Suburb = @inpsub)
    AND
    (@inpage is null OR t.Age between @inpage and @inpage + 5)

是的，你在哪儿ê 杰伊。不确定您的年龄是什么数据类型。但如果年龄是char：

SELECT

* 

FROM table 
WHERE
Gender IN (('Male', 'Female') OR (Gender LIKE ('Male' AND 'Female')))
AND (Suburb is NULL OR Suburb IN ('Bellville', 'Durbanville', 'Brackenfell'))
AND (Age IN ('5-10', '11-16', '17+') OR AGE IS NULL)

如果年龄是整数：

AND ((Age = 5 < Age) OR (AGE IS NULL))