Re: Is this a valid Update Query

2004-09-07 Thread Mark C. Stafford
On Tue, 7 Sep 2004 15:13:25 -0700, Allen Weeks <[EMAIL PROTECTED]> wrote: > Is this a valid query >Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField > = 'keydata' Hi Allen, I notice that you're using both single- and double-quotes. I'm in the habit of using on

Is this a valid Update Query

2004-09-07 Thread Allen Weeks
Hi All, Is this a valid query and will it achieve the result of appending a carriage return and some text to the current contents of a "text" type field: Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField = 'keydata' Thanks in advance. Allen -- MySQL General