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 >