Arthur Fuller
artful at rogers.com
Thu May 20 18:19:57 CDT 2004
In my SQL Tips column at builder.com I did this one too. You really ought to read my stuff, Martin (nudge, nudge, wink, wink). What I wrote is a function that returns a table from an input string consisting of a sequence of comma-delimited values. Data type is unimportant, since it takes advantage of SQL's ability to handle quotes around any value (i.e. "Balance = 12345" = "Balance = '12345'"). If you want the code, msg me. Sorry for the late response, but I've been buried under a mountain of work lately. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Saturday, May 08, 2004 5:54 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] List Box values to SP I need to pass the values from a list box in Access to a stored procedure which does a multi table insert.Unless of course theres a better way to do this? Martin _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com