>Kevin,
>
>Try using the COALESCE(...) function instead because it can accept more than two parameters.
>
>
>COALESCE(r.Status,'') = COALESCE(@Status,r.Status,'')
>
>
>Hope this helps.
>Kurt
>
Kurt,
Using COALESCE(r.Status,' ') will make this query non-surgable.
If it's not broken, fix it until it is.
My Blog