Hi,

It may be that the last statement might be as:

EXEC (@SQL+@Prog+@SQL1+@Chapt @sql2 +@State + @sql3 +@County + @sql4 + @Zip+''')')

Regards