Are you sure that its only returning name as if you are looking at it in your browser the browser will think that the <> section is a tag... Ensure that you wrap the output with HTMLEditFormat
Ie <cfoutput> #HTMLEditFormat(makeFriendly.Friendly)# </cfoutput> HTH -----Original Message----- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 17:31 To: CF-Talk Subject: QofQ question... Can you concatenate fields in a query of queries select statement? <cfquery name="makeFriendly" dbtype="query"> SELECT Name + ' <' + Email + '>' AS Friendly FROM getEmails </cfquery> .it's only returning the "Name" and not "Name <[EMAIL PROTECTED]>" in the Friendly column. I know I should (and I am going to implement) concatenating the fields in the original query. But I'm just setting up a debug for my app and I came across this and I just got's to know-> Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists