On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > Punkish, > > I don't want to replace it. I want to add to the end of field. So, I did > not know that I could do, > > UPDATE table SET field = field && 'data to be added' WHERE id = 55;
first, you should use || as the string concat operator, although && might also work. I haven't tried it though. That said, I hate to tell you that whether you do field = field || 'data to be added' or given field = 'value' you do field = 'value with more text' you are replacing the value of the field, and that was what I was trying to illustrate. I should have really said field = field || ' with more text' > > So, I think this should do it. I will give it a try and get back to the > group. > > thanks all. > > josé > > ----- Original Message ----- > From: "P Kishor" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Wednesday, January 30, 2008 2:59 PM > Subject: Re: [sqlite] Adding data to the end of a column > > > > replace the field with new value. > > > > UPDATE table SET field = 'value with more data' WHERE field = 'value' > > > > On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > >> > >> Greetings. > >> > >> Is there a way to add data to the end of a field? I know I select that > >> field, import the data into a variable and then add whatever to the end. > >> What I am trying to do is exactly NOT that. :-) So, instead, just add > >> say a > >> line or two of text to a field. > >> > >> Is this possible? > >> > >> thanks, > >> > >> josé > >> > >> > >> ----------------------------------------------------------------------------- > >> To unsubscribe, send email to [EMAIL PROTECTED] > >> ----------------------------------------------------------------------------- > >> > >> > > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
