Of course you could return the whole value and then preform the listGetAt on the column but like Aaron said, we normally use Oracle too for things like that. Pull the data correctly out of the DBMS and no fooling with later
On 4/27/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > I do it in Oracle through a couple of different ways but almost always > narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR > functions to find positionings to pull out the data. > > On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > > > > Is something like this possible in SQL? If so, how? > > > > <cfquery name="getBlah" datasource="#DSN#"> > > SELECT OrderID, listGetAt(FinalBillTo,2,"~") FROM Orders WHERE CustID = > > 1234 > > </cfquery> > > > > Thanks, Che > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204652 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
