List:General Discussion« Previous MessageNext Message »
From:calvin guther Date:August 5 2004 12:57pm
Subject:RE: concatenation
View as plain text  
>I have been trying to concatenate two fields with MySql contaning the
>NAME and SURNAME, whatever tool I use, it returns me all the time a
>"number".  What it is wrong with my request?

it's hard to tell without knowing your request, but you could try this one:

SELECT CONCAT( NAME, ' ', SURNAME )  FROM  <table_name>

calvin:-)

_________________________________________________________________
Wußten Sie, daß Sie Ihren Hotmail-Posteingang auch über den MSN Messenger

abrufen können? http://www.msn.de/messenger Jetzt kostenlos downloaden und 
einfach testen!

Thread
concatenationFernand St-Georges5 Aug
  • Re: concatenationMartijn Tonies5 Aug
RE: concatenationcalvin guther5 Aug