[AccessD] SQL Server - Turn field list into string

I have built a set of three views - vFields_tblOrderData, 
vFields_vOrderCriteria and vFields_vOrderCriteriaNotInTblOrderData.

So I have a list of just the fields not in common between the two 
objects.  What I need now is example code or web references that show me 
how to work with tables (recordsets), looping and so forth.  What I 
would do in DAO is to open a recordset, move through the records pulling 
the contents of a field called "Column_Name" and appending that to a 
string, complete with commas and so forth.  I have never done that kind 
of thing in a stored procedure, nor even seen code to do so.

-- 
John W. Colby
www.ColbyConsulting.com