CREATE PROCEDURE p_table_update @pkfield INT, @field1 VARCHAR(50), @field2 VARCHAR(50) = NULL AS UPDATE table SET field1 = @field1, field2 = @field2 WHERE pkfield = @pkfieldIs there a way that if I don't send the @field2 parameter, that it gets 'ignored' in the UPDATE statement? Other than writing 2 UPDATE statements of course!