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;
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]
-----------------------------------------------------------------------------
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
