All I could find was "SQL string length (batch size) 128 KB " Now, I don't know if the ODBC has a limit or an ASP statement, you may want to look their next. Sorry I don't have a simple answer for your question.

>I am creating and app to access SQL Server 6.5 through a web interface (ASP) as those were the client's specs and requirements.
>
>The app allows the user to fill in a form with criteria and it then builds a SQL query. This is a simple query that looks something like:
>

SELECT * FROM MyTable
>WHERE MyVar IN (var1,var2,var3,....varN)

>
>The VarN string gets filled at runtime with the proper values (actually account numbers). The samples I was running today had a string length (just the IN clause, w/o the Select from, etc. of 470 chars).
>
>The question is what is the upper limit here, in string ;ength and in number of parameters (VarN) before the query crashes and the web user gets an ugly SQL error. I need to be pro-active and limit their expansion before it hits.
>
>Does anybody know the answer? Don't tell me to RTFM. I did and couldn't find it < g >