roy.tollison (11/16/2013)
i guess i could put the results into a table then use a cursor and process all the rows and use the value in the cf_field(real column name is stored in there) and then build an update command to load up the int value that is assigned to that column for that row.will be a while before i get all the basics in place and all the bugs worked out...
Heh... yeah. Let us know how the cursor thing works you for you. 😉
Since folks still have questions about what you're actually trying to do, I recommend that you try to clarify the problem using the suggestions from the 1st link under "Helpful Links" in my signature line below. Obviously, you don't have to post the whole table or a million rows of data but there's nothing like cold hard data in a table to clarify a problem.
--Jeff Moden
Change is inevitable... Change for the better is not.