Home » RDBMS Server » Server Administration » Re: Updating a table
Re: Updating a table [message #372993] Wed, 21 March 2001 11:36
Prem
Messages: 79
Registered: August 1998
Member
mel,

if i understood ur question right, you need to replace a portion of the text in the column with something else. then where does the 2nd column come in this?

update emp set ename = replace(ENAME, 'AR','$');
the above sql will replace all occurances of "AR" in the names in the EMP table with "$". If this is not your questions, can you pls give more details?

hth

Prem :)

Report message to a moderator

Previous Topic: SQL
Next Topic: calculating time between two events
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 06:58:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.