Hello,

I have 2 params. There are 4 situations, one where both param1 and param2 are not null, where one of param1 or param2 is null and the other isn't, or where both are null. Is there a simple way of querying based on this instead of writing four separate queries?

Thanks,

Brian

__________________
Brian

Is there any default value specified for those params?

Try using COALESCE function to achieve that.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay is right, you just need to give both params a default value of NULL and then COALESCE away the defaults, like this
...
WHERE Field1 = COALESCE(@param1, Field1)
AND Field2 = COALESCE(@param2, Field2)

then if either of the params are not supplied (i.e. = NULL) they effectively get ignored.

rgds
Phil