I am asking here, before I go searching and digging in the documentation and web resources, because you all often provide a better answer faster then I can on my own. Anyway, what SQL syntax, if any, is in a CF query of a query to manipulate and modify string content of fields? I have a record set of e-mails that have been generated by a tool that validated them. I would like to create a report of how many we have from various domains. I can see how I could do this manually by looping through the query manipulating each record one at a time and counting up each domain. But, I was wondering if I can do this in a query of a query using syntax you can usually find in more robust RDMS's. So, is this possible? -------------- Ian Skinner Web Programmer BloodSource <file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org> www.BloodSource.org <http://www.BloodSource.orgSacramento> Sacramento, CA
"C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187096 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