I am learning to batch execute SQL commands through ASP. Can someone tell me how to concatenate SQL commands in a SQL string?<BR>For example, how to I put this isql batch into ASP:<BR><BR>set rowcout 50<BR>select * from item<BR>go<BR><BR>If I do this:<BR>sSQL="set rowcount 50 "<BR>sSQL=sSQL & "select * from item"<BR><BR>It will give me syntax error through ASP. Do I need a hard return at the end of the set command. How?<BR><BR>Please help!<BR><BR>newbie