From: Martijn Tonies Date: August 5 2004 10:31am Subject: Re: concatenation List-Archive: http://lists.mysql.com/mysql/170373 Message-Id: <019c01c47ad7$5cccf5f0$0a02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit > 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? Hard to tell without showing your query, isn't it? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com