And yes, 'Concat' is a MySQL function and will work perfectly. Just didn't know what to call what I needed. Haven't used that function before.
Thanks, m!ke! Rick > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, May 19, 2008 12:38 PM > To: CF-Talk > Subject: RE: How to combine multiple fields into one alias? > > After reading your original post, again, I think you may get quite a few > suggestions that you need to improve your database schema. > > If you have control over the database schema, you may be better of > storing your remarks in different records, rather than different fields. > In other words, store each remark in its own record, with an identifier > of the remark's "parent". > > m!ke > > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, May 19, 2008 11:32 AM > To: CF-Talk > Subject: RE: How to combine multiple fields into one alias? > > You need to "concatenate" the values. > > In DB2, you use ||. In SQL Server you use +. > > SELECT col1 || col2 AS newCol > SELECT col1 + col2 AS newCol > > I'm not sure about MySQL, but it should be similar. > > You might also find a CONCAT() database function with unlimited > arguments: > > SELECT CONTACT(col1, col2, coln) AS newCol > > m!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
