Give an actual example of what your list looks like, and also exactly what you want the resulting SQL to be.
--- Ben -----Original Message----- From: Devi r [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 1:48 PM To: CF-Talk Subject: Re: Help Needed!!! Urgent Hi, I need to retrieve all the tokens from the value " A & B" with space as delimiter I mean i need the result as 1)A 2) & 3)B Is there any function to do it??? regards, devi bala >If Forta agrees with us J.J then we are right, haha! I don't think I have >ever used getToken(). > >Dan Vega > >On 6/24/07, J.J. Merrick <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

