Problem added text to the end of existing text field...

[lidds]

Hi,

I need some help, as always, I currently have a table called 'notificationMessageTbl' and I have a TEXT field called 'userReadID' what I want to do is add text to the end of current text within the field using SQL

If I use the following code it just replaces the exsisting text with '12,' and does not append.

UPDATE notificationMessageTbl SET userReadID = '12,'

Thanks in advance

Simon

 

[giadich]

UPDATE notificationMessageTbl SET userReadID = userReadID + 'something else'

 

[cjard]

If I use the following code it just replaces the exsisting text with '12,' and does not append.

UPDATE notificationMessageTbl SET userReadID = '12,'

OK, think about this in VB terms. Would you come to us and say:

"In this code, when i messagebox, I see my hello world is lost, and I wanted the new text to be after it:

Dim s as String
s = "Hello World"

s = ", Goodbye World"

MessageBox.Show(s)

Surely you would see it had to be:

s = s & ", Goodbye World"

?

Its the same difference here in SQL..