Results 1 to 9 of 9

Thread: Update a word in entire table [RESOLVED]

Threaded View

  1. Dec 22nd, 2005, 08:23 AM #1
    usamaalam
    usamaalam is offline

    Thread Starter
    Frenzied Member usamaalam's Avatar
    Join Date
    Nov 2002
    Location
    Karachi
    Posts
    1,308

    Update a word in entire table [RESOLVED]

    Hello everybody,

    Someone generated SQL script for data migration and misspelled the word "Install" with "Instal". This is only in one field of a table but the table contains massive records.

    Is there some way to write a script to update Title field in such a way if it contains the word Instal, it should be replaced with Install. I have seen Instal is at the end of the other data.

    For example:
    abc
    abc2
    xyz Instal
    xyz2Instal

    This field should be:
    abc
    abc2
    xyz Install
    xyz2Install

    Thanks.
    Last edited by usamaalam; Dec 22nd, 2005 at 09:17 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width