Kevin, Check out www.cflib.org, they have a ton of simple custom tags that will help do little tasks. They probably have one that will format a date into a phone number. I think using a Mid function to pull the left, middle, and right string values from the number will work as someone suggested.
Adaryl, I'm pretty sure that QofQ won't successfully handle all types of joins. It lacks 100% compatibility with Ansi standards on SQL. Sorry. Try replacing the *= with the more usual left outer join type of statements. *= is an older standard that while still somewhat supported in SQL Server (and fully supported in Oracle I think), it may not be compatible with CF in a QofQ. Ryan ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
