Thanks too jpipes. Think that would work too.

I just figured this out and it seems to work, this is what I've done:

....Get the field names into a rs as @FieldName then loop....

DECLARE @RetrievedValue nvarchar(50) ,

@sql nvarchar(1000),

@col sysname,

@colVal varchar(50)

SELECT @col = @FieldName

SELECT @sql = N'SELECT @colVal =' + @col + ' FROM Jobs WHERE ID = '''+ @ID +''''

EXEC sp_executesql @sql, N'@colVal varchar(50) OUTPUT', @colVal OUTPUT

SELECT @RetrievedValue=@colVal

....do stuff based on what I got back in @RetrievedValue then loop around again.....

Really appreciate people helping out, thanks guys.