There can be problems with performance and UDF's if not coded correctly - be prudent with your execution plans.
If anyone is interested, I have the following SQL UDF's to work with lists.. listAppend listDeleteAt listFirst listGetAt listInsertAt listLast listDeleteAt listLen listPrepend listSetAt listToTable N -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 06 December 2005 05:09 To: CF-Talk Subject: RE: SQL Question. Compare one list to another Pretty good read in general too about UDFs in sql ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 11:55 PM To: CF-Talk Subject: Re: SQL Question. Compare one list to another Ah, duh, missed the trailing "d" on the next line. my bad. On 12/5/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > Not if you piece it back together right.... > > http://mkruger.cfwebtools.com/index.cfm > ?mode=alias > &alias=sql%20udf%20listfind > > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226151 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
