Post reply

Update a text field in SQLServer 2000

  • June 20, 2008 at 6:20 am

    #187385

    I have a text field in a SQLServer 2000 database that I need to add some additional text to. I can't seem to figure out how to code the update statement. It appears normal concatenation doesn't work. Here's my statement:

    Update PatientTable

    Set Notes = 'New data goes here' + Char(10) + Char(13) + Notes

    Where PatientId =

    (Select PatientID From PatientVisitTable

    Where TicketNumber = 9)

    Thanks!!

  • June 20, 2008 at 9:28 am

    #831889

    Try this:

    Update PatientTable

    Set Notes = NOTES + ' This is a new TEXT Message'

    Where PatientId =

    (Select PatientID From PatientVisitTable

    Where TicketNumber = 9)

    Maninder
    www.dbanation.com

  • June 20, 2008 at 9:49 am

    #831917

    Look up UPDATETEXT. It is needed once you get above a certain size.

  • June 23, 2008 at 12:13 am

    #832478

    Hi...

    Try this:

    Update PatientTable

    Set Notes = 'NOTES' + ' This is a new TEXT Message'

    Where PatientId =

    (Select PatientID From PatientVisitTable

    Where TicketNumber = 9)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply