Top "Select-case" questions

javascript: using a condition in switch case

Sorry for that dumb question. How can I use a condition for a case in the javascript switch-case language element? …

javascript conditional-statements select-case
What is the equivalent of Select Case in Access SQL?

I have a query which includes fields named openingbalance and commissions. I would like to compute values for commissions based …

ms-access select-case
Excel VBA: Select Case if ActiveCell like "*string*"

I'm working on a macro that takes the current value of the ActiveCell and changes that value based on a …

excel vba wildcard select-case vb-like-operator
Select Case on an object's type in VB.NET

I'm not sure if this valid C#, but hopefully you get the idea. :) switch (msg.GetType()) { case ClassA: // blah case …

vb.net switch-statement select-case
Oracle SQL query with CASE WHEN EXISTS subquery optimization

I'm using the following query to create a view in Oracle 11g (11.2.0.3.0). CREATE OR REPLACE FORCE VIEW V_DOCUMENTS_LIST ( …

oracle subquery query-optimization select-case
Can you use .Contains(string) with a Select Case Statement?

Is there anyway I can build a Select statement that uses the Contains function? Like this: Select commentStr Case commentStr.…

vb.net select-case
How can you use COUNT() in a comparison in a SELECT CASE clause in Sql Server?

Let's say you want do something along the following lines: SELECT CASE WHEN (SELECT COUNT(id) FROM table WHERE column2 = 4) &…

sql sql-server count aggregate-functions select-case
Multiple select cases in VB.NET

I have tried the below: Select Case Combo1.SelectedItem Or Combo2.SelectedItem But I get the error: Conversion from String "…

vb.net visual-studio-2008 select-case
Why should I use exit select?

Here are a couple of questions I gathered regarding exit select... Is there any reason for using exit select in …

vb.net select-case
Access 2010 VBA Select Case Statement

I am trying to build a function where based on a string comparison use a specific formula The problem I …

ms-access vba ms-access-2010 select-case