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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2009-11-17 : 03:13:44
|
| i have a query select id,regname from new usersHow can i seletct that if regname is blank or null then it should select 'processing' instead of blank.is that possible with a case statement in the query? |
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-11-17 : 03:50:43
|
| select id,CASE WHEN regname IS NULL OR regname='' THEN 'Processing' ELSE regname END from new users |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-17 : 04:02:15
|
| or select id,CASE WHEN regname>''THEN regname ELSE 'Processing' END from new users MadhivananFailing to plan is Planning to fail |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-17 : 04:26:37
|
| thanks :) |
|
|
|
|
|
|
qury changing values