RE: SQL IN Statement

[Daniel Elmore]

Robert, to use the char string in an SQL IN clause most people would say just use dynamic SQL (EXEC ...). However, I would never recommend anyone to use dynamic SQL unless it was an usual circumstance. Instead, I use a UDF called ListToTable which converts a varchar list to a table variable (not a temp table!) with rows. Therefore you can write code like so:   DECLARE @myIDString varchar(100) SET @myIDString = '2,3,4,5,6,7,8'   SELECT * FROM entCustomers WHERE CustID IN (select ID from dbo.ListToTable(@myIDString) )   Does that make sense? If you want the code for the UDF let me know.   Daniel Elmore        -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Robert Shaw Sent: Friday, January 28, 2005 10:25 AM To: list@dfwcfug.org Subject: SQL IN Statement I have a cookie that hold multiple ID numbers for specific jobs. I want to pass that through a storedProcedure to the server to use as an IN clause. I have to pass the string as text, but the value on the SQL server site has to be numeric.   I can write the entire query string and pass it to SQL server but is there a way to just pass the values needed for the IN clause.   What am I missing?.         Robert Shaw Edata Alliance, Inc. www.EdataAlliance.com DataOnTheWeb www.DataOntheWeb.com 972-463-3515 972-463-9215 972-463-9896