Hmmm... maybe the DAO type-deal, but that's a lot of work. The idea was to do it without looping the query first, so the isValid I don't think would work.
The regex I mentioned was basically a way of putting some type of selection in the query itself, saying, "Grab me records with valid emails", which I presume the MySQL regex engine is capable of, dunno for sure, and no idea whatsoever about MSSQL and regex. Just spreading out the work load, CF shouldn't have to do it all! ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237849 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