> I have a similar question... > in the stored proc, say you pass in a comma delimited list, how do you break it apart? > Are there list functions within T-SQL?
t-sql isn't suited for this. you could do it w/dynamic sql (building the code & data into an sql statement) but then the sp won't buy you much & might as well do it via cfquery (unless you have other reasons for using an sp). its often recommended (on the sql server list) to stuff the list into a temp table via the "client" (cf) & work with that in the sp. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists