Thanks!!!
On 1/20/06, Cornillon, Matthieu (Consultant)
<[EMAIL PROTECTED]> wrote:
> Aaron,
>
> I Googled "MySQL concatenation operator" and eventually came to the
> CONCAT function, pasted below. I think searching for
> "DB_SOFTWARE concatenation operator" should help others find their
> db-specific answers as well.
>
> HTH,
> Matthieu
>
> CONCAT(str1,str2,...)
>
> Returns the string that results from concatenating the arguments. May
> have one or more arguments. If all arguments are non-binary strings, the
> result is a non-binary string. If the arguments include any binary
> strings, the result is a binary string. A numeric argument is converted
> to its equivalent binary string form; if you want to avoid that, you can
> use an explicit type cast, as in this example:
>
> SELECT CONCAT(CAST(int_col AS CHAR), char_col);
>
> CONCAT() returns NULL if any argument is NULL.
>
> mysql> SELECT CONCAT('My', 'S', 'QL');
> -> 'MySQL'
> mysql> SELECT CONCAT('My', NULL, 'QL');
> -> NULL
> mysql> SELECT CONCAT(14.3);
> -> '14.3'
>
> From some MySQL online manual:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230126
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
