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 |
|
eembme
Starting Member
18 Posts |
 Posted - 2007-03-26 : 17:04:19
|
| (CASE WHEN (Sheet1$.NOTES = 'unscheduled visit')THEN 1 END) AS [unscheduled visit]I am not sure how to use the Case statement with more than one Noteieunscheduled visitearly terminationI tried (CASE WHEN (Sheet1$.NOTES = 'unscheduled visit') OR (Sheet1$.NOTES = 'early termination')THEN 1 END) AS [unscheduled visit](CASE WHEN (Sheet1$.NOTES = 'unscheduled visit'OR'early termination')THEN 1 END) AS [unscheduled visit]I am confused on the proper syntax. All the example I can find use a numeric value. Thanks! |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-26 : 17:14:24
|
| http://msdn2.microsoft.com/en-us/library/ms181765.aspx |
 |
|
|
|
|
|
Case statement