[RESOLVED] [SQL 2000] Conditional Conditions in SP

[si_the_geek]

I would personally go for something like this:

WHERE
        ((@From Is Null) OR ([tblLoans].Created >= @From)) AND ((@To Is Null) OR ([tblLoans].Created <= @To)))
            AND ...