Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you update one letter in a field? 2

Status
Not open for further replies.
forsyte

forsyte

Technical User
Jun 27, 2002
4
US
I have over 3000 records that need one particular character replaced. Anyone know how this is done in Enterprise Manager?
 
Sort by date Sort by votes
update t
set c = replace(c,'<your special character>','<new character'>)

You are better off puting these questions in a SQL Server forum.
 
Upvote 0 Downvote
swampboogie:

COOL BEANS! It worked. Thanks for the quick response.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
189
mikrom
mikrom
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
345
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
183
carp
carp

Part and Inventory Search

Sponsor

Back
Top