Yeah, that seems to do the trick.

~~Bonnie



>Hey, Bonnie,
>
>Thanks! Excellent point...would the following address that?
>
>

>  ...AND ISNULL(middle,'')    = COALESCE(@middle, ISNULL(middle,''))
>

>
>I did one test and it worked fine. I want to try a few more examples.
>
>Thanks,
>Kevin