You can combine literals and selected columns at free will in SELECT:
sql= "INSERT INTO table(answer1)
sql= "select '" & answer1 & "', * from web where identity=" & identity
You have to make sure the INSERT and SELECT column lists match.
Let us know if helpful.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/