How to add String to existing value of String

[David DeSana]

I need to modify the value of file names in a table.  The strings represent 
an image file path and are stored in a char column in the table.  Here is a 
sample of the values:

\products\1_TH.JPG
\products\2_TH.JPG
I would like to perform the following
UPDATE test.Items SET Desc='New'+Desc
I've been able to get the update to work on numeric values based on the 
MySQL docs but cannot figure out how to perform the update on strings.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]