>Kevin,
>
>We use the COALESCE() function, it makes the code a whole lot easier to maintain, here's an example:
>
>WHERE p.AppKey = COALESCE(@AppKey, p.AppKey)
> AND pc.CategoryTypeKey = COALESCE(@CategoryKey,pc.CategoryTypeKey
> AND psc.ProjectStatusCodeKey = COALESCE(@StatusKey,psc.ProjectStatusCodeKey)
>
>
>Basically for each variable, if the variable is null, then it will retrieve all values, otherwise it will only pull in records that match the variable. It is very easy to add additional filter criteria.
>
>Kurt
Exactly what I was saying before John came along :) You can use either COALESCE or ISNULL here, it doesn't matter - your preference.
If it's not broken, fix it until it is.
My Blog