David, Maybe the CONCAT() function is what you are looking for ?
Freddie > -----Ursprüngliche Nachricht----- > Von: David Blomstrom [mailto:[EMAIL PROTECTED] > Gesendet: Sonntag, 27. Juni 2004 08:07 > An: [EMAIL PROTECTED] > Betreff: Merging 2 Fields > > I think I recall a thread where someone mentioned merging two > fields. If that can be done, I'd like to know how. > > For example, suppose I have a field filled with place names, > next to a field filled with links: > > California | <http://www.california.gov/> Florida | > <http://www.florida.gov/> > > I'd like to merge the columns, so the two columns are > displayed as one: > > <http://www.california.gov/>California > > I'd have to add the closing </a> tag somehow, but I think I > know how to do that. > > So how do you merge fields? > > Thanks. > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]