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 |
|
dnreddy
Starting Member
3 Posts |
 Posted - 2007-07-25 : 06:32:03
|
| Hi SQL> select * from info;NAME GENDER---------- -------ram fmohan flalitha mradha m MY PROBLEM IS WHERE GENDER='M' THAT SHOULD BE CONVERTED TO 'F' AND VICE VERSA. i.eNAME GENDER---------- -------ram mmohan mlalitha fradha f how to write the query.Please help me. dnreddy |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-25 : 07:42:56
|
| moved from article discussion_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-25 : 08:30:25
|
Oh ! It's the popular sex change question 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-25 : 08:35:37
|
you want to kill me with laugher, don't you tan  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-25 : 09:05:06
|
| no the original one just started the job... looks like you're trying to finish it _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Query help
Maybe you missed that.