Carriage return in query ???

2006-04-21 Thread John Thorne
Hello Trying to CONCAT several fields into one with carriage in a Dreamweaver/php recordset I found an example for MS SQL SELECT recid, CoName, Drive, Del_Proj, 'Co: ' +CoName + CHAR(13) + 'Acct: ' + Acct + CHAR(13) +'Drive: ', Drive) AS Info FROM data ORDER BY recid ASC Desired Result:

RE: Carriage return in query ???

2006-04-21 Thread George Law
/en/function.stripslashes.php -Original Message- From: John Thorne [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 9:07 AM To: 'mysql@lists.mysql.com' Subject: Carriage return in query ??? Hello Trying to CONCAT several fields into one with carriage in a Dreamweaver/php