>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.