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

[si_the_geek]

Which database system are you using?

Assuming SQL Server (I think that's the message it shows!), you could try this:

userReadID = Cast(userReadID as VarChar(Length(userReadID)))+ '12,'

..note that this will only work if the length of the field is within the limits of the VarChar data type.

[lidds]

Sorry to ask a stupid question, but will the code look like this:

UPDATE notificationMessageTbl SET userReadID = Cast(userReadID as VarChar(Length(userReadID)))+ '12,'

Also I am using SQLServer

Thanks

Simon