Thanks Mike ... I like that.

~~Bonnie


>This is an example of a very common technique:
>
>

>CREATE PROCEDURE MyProc
> @mytable_ID int,
> @One   char(1) = NULL,
> @Two   char(2) = NULL,
> @Three char(3) = NULL
>AS
>
>UPDATE mytable
> SET one = ISNULL(@one, one),
> two = ISNULL(@two, two)
> three = ISNULL(@three, three)
>WHERE
> mytable_ID = @mytable_ID
>

>
>-Mike