i have a table who has in one of his fields (tQuerys) a string query sentence<BR><BR>i have to...<BR><BR>sql = "select * from tablequeris"<BR>Set objRS = server.createobject("adodb.recordset")<BR>objRS.op en sql,objDB<BR>stringy =objRS("tQuerys") <BR>... and i see that stringy has: "select * from othertable where cod = "&tcod&" and yknow ="&tnow&""<BR><BR>objRS.Close<BR>objDB.Close<BR>Se t objRS = Nothing<BR>Set objDB = Nothing<BR><BR>.... i load at the variables..<BR>tcod = 2<BR>tnow =3<BR><BR>...cause i need to string y appears like..<BR>select * from othertable where cod = 2" and yknow =3<BR>to use it in another connection and in another recorset of another query to another table...<BR><BR>how can i get that???<BR><BR>