I figured it out. The maximum length you can pass into a SQL Server stored procedure is 8000 chars, so you just specify varchar(8000). If you happen to send in a string longer than the specification, it will be truncated, resulting in an error.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Duane Ronan Sent: Friday, September 30, 2005 5:54 PM To: [email protected] Subject: Long string passed into SQL Server Stored Procedure? Hey Gang, I need to pass in a long WHERE clause into a stored procedure. The WHERE clause is longer than 255 characters. Is this possible? Thanks for your input. Duane Ronan ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
