Results 1 to 2 of 2

Thread: UPDATE Query

  1. #1
    Join Date
    Dec 2012
    Posts
    5

    UPDATE Query

    I have a field in SQL Server table that somehow got data altered. So the data reads like this Test ,Test Is there a way for me to run an update query which will modify the data back to the original formatting of Test, Test?
    Last edited by IndigoMontoya; 12-21-12 at 18:26.

  2. #2
    Join Date
    Feb 2012
    Posts
    141
    Try this:
    update mytable
    set mycolumn = replace(mycolumn, ' ,', ',')

    This will replace ' ,' with just a single comma. And of course mytable = your table name and mycolumn = your field name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •