Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roxcy
Yak Posting Veteran
58 Posts |
 Posted - 2006-08-16 : 02:32:41
|
| Hi, I have a table Named CTN Which has columns NAME,ADDRESS & STATUS & its values are ABC,STR12,RR.So my initial status is RR.I want my status to change from RR to MOU on Click event of a Button.The Click Event is from another Form.What Should be my query? Plz Help.. Thanks......... |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2006-08-16 : 02:39:53
|
Not sure if this is what you want but...update CTN set status = 'MOU' where name='ABC' and where 'ABC' is the name of the record you want to change (this assumes the name is unique)--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-16 : 02:42:51
|
| [code]Update CTN SEt Status = Replace(Status,'RR','MOU') Where Name = 'XYZ'[/code]Chirag |
|
|
|
roxcy
Yak Posting Veteran
58 Posts |
Posted - 2006-08-16 : 02:43:55
|
| Thanks Buddy..... |
|
|
|
roxcy
Yak Posting Veteran
58 Posts |
Posted - 2006-08-16 : 02:44:26
|
| Thanks Chirag |
|
|
|
|
|
|
Update Rows