and use the values for each line in the below query as the @find and @repldeclare @find as varchar(12), @repl as varchar(12)SET @find = (select sEmployeeID from tblPREE);SET @repl = (select sEmployeeIDf from tblPREE);EXEC SearchAndReplace @find,@replGO the error I get when I run this is:Server: Msg 512, Level 16, State 1, Line 2Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.Server: Msg 512, Level 16, State 1, Line 3Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.Thanks for all your help,Scott