declare @state char(2) declare @lname varchar(40), @fname varchar(20) SET @state = 'CA' DECLARE authors_cursor CURSOR FOR SELECT au_lname, au_fname FROM authors WHERE state = @state OPEN authors_cursor FETCH NEXT FROM authors_cursor INTO @lname, @fname WHILE @@FETCH_STATUS = 0 BEGIN PRINT @fname + space(1) + @lname FETCH NEXT FROM authors_cursor INTO @lname, @fname END CLOSE authors_cursor DEALLOCATE authors_cursor>Hi!,