Re: CONCAT-Problem

["Cyrill Schumacher" <webmasterbhs_(at)_bluewin.de>]

>Das Concat weiss ich jetzt auch nicht was das bezwecken soll.

CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments. Returns
NULL if any argument is NULL. May have more than 2 arguments. A numeric
argument is converted to the equivalent string form.
mysql> select CONCAT('My', 'S', 'QL');
        -> 'MySQL'
mysql> select CONCAT('My', NULL, 'QL');
        -> NULL
mysql> select CONCAT(14.3);
        -> '14.3'

MySQL automatically converts numbers to strings as necessary, and vice
versa:

mysql> SELECT 1+"1";
        -> 2
mysql> SELECT CONCAT(2,' test');
        -> '2 test'

If you want to convert a number to a string explicitly, pass it as the
argument to CONCAT().

kiri


---
*** Weitere Infos zur Mailingliste und MySQL unter www.4t2.com/mysql