Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 26, 1999

Changing the Text Value of a Populated Field

Question:
How do I correct a spelling error in a table? I am at a loss as to where to start.

Answer:
Hoping for the best, I'd say that what you need to do is something like this:

 
UPDATE MyTable.MyField SET MyTable.MyField = to NEWVALUE where MyTable.MyField = OLDVALUE
On the other hand, if things are more complex in your situation, you will have to use READTEXT and WRITETEXT to extract the part of the field that needs fixing and then put it back.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap