Lynn, thank you....

Now after inserting rows into GwenF_department , and executing the function .....

drop function dbo.udfSalaryRaise;

CREATE FUNCTION udfSalaryRaise()

RETURNS @Results TABLE (

departmentname varchar(25),

depttypevarchar(10),

SalaryAdjustment...

I am getting this same error message ...Column name or number of supplied values does not match table definition.

My table definition is as...