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:
Co: ABC
Acct: 123
Drive: Summer Special
mySQL:
SELECT recid, CoName, Drive, Del_Proj,
CONCAT('Co: ',CoName, what syntax here??,'Acct: ',Acct,, what syntax here
??,'Drive: ', Drive) AS Info
FROM data
ORDER BY recid ASC
have tried '\n' '\\n' '\r' '\\r' .... etc
help
thanks
jrt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
