Hi, I'm on Oracle 9i. I have a query (call it AllResults) that is returning a column (call it MyColumn) that's value looks like this:
'identifier|5,2,3,4,45,7' Each row may have a different 'identifier' and a different quantity of numbers. Basically, there are two values in this column. identifier & numberlist separated by a pipe Now, I need to build a query of queries that queries this existing recordset and only returns the records which has a number that I'm comparing against. I know I can do this in CF by looping over the recordset, but I'm trying to avoid that (for processing time sake). Here's the pseudo code of what I'm trying to do: (idnumber is a variable in my code and will be ONE of the numbers listed in the numberlist) select * from AllResults WHERE idnumber is found in the list of numbers located in the MyColumn field I only want the records that have 'idnumber' IN the list of numbers I'm sure this can be done with some SQL code and since I'm not a SQL guru, let alone Oracle, any help or suggestions would be appreciated. Thanks! Dave ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215286 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
