Can you use .Contains(string) with a Select Case Statement?

Posted by Louise on Stack Overflow See other posts from Stack Overflow or by Louise
Published on 2010-04-15T17:58:04Z Indexed on 2010/04/15 18:03 UTC
Read the original article Hit count: 499

Filed under:

select

|

select-case

|

vb.net

|

visual

|

basic

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

Select commentStr
    Case commentStr.Contains("10")
    Case commentStr.Contains("15")

© Stack Overflow or respective owner

Related posts about select

HTML muliple select should look like HTML select

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below ` <SELECT NAME="toppings" MULTIPLE SIZE=5> <OPTION VALUE="mushrooms">mushrooms <OPTION VALUE="greenpeppers">green peppers </SELECT> When the size is set to 1 small scrollbar appears… >>> More
MySQL Query Select using sub-select takes too long

as seen on Stack Overflow - Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables: SELECT * FROM table_1 WHERE id IN ( SELECT id_element FROM table_2 WHERE column_2=3103); This query took approximatively 242 seconds. But when I executed the subquery SELECT id_element FROM table_2 WHERE column_2=3103 it… >>> More
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to… >>> More
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?

as seen on Programmers - Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 }; var contacts = from c in context.Contacts where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault() select c; foreach (var item in contacts) Console.WriteLine(item.ContactID); Linq-to-Entities… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More

Related posts about select-case

Problem with a "Select Case"

as seen on Stack Overflow - Search for 'Stack Overflow'
i wrote the following section below. when debugging, i see that i enter the first Case okay. my problem is with the second Case - it does not enter it and goes to the error messege. what do i do wrong? Select Case Data_Rate Case "1", "2", "5.5", "11", "6", "9", "12", "18", "24", "36", "48", "54" … >>> More
Excel VBA Select Case Loop Sub

as seen on Stack Overflow - Search for 'Stack Overflow'
In my excel file, I have a table setup with formulas. with Cells from Range("B2:B12"), Range ("D2:D12"), and etc every other row containing the answers to these formulas. for these cells (with the formula answers), I need to apply conditional formatting, but I have 7 conditions, so I've been using… >>> More
VB.NET Select...Case Statement Equivalent in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I just started using C# and I've got a couple of issues. Is there any way to code the C# equivalent of the VB.NET Select statement like the following? Select Object.Name.ToString() Case "Name1" 'Do something Case "Name2" 'Do something else Case Else 'Do the default… >>> More
Select...Case VB.NET to C# Equivalent

as seen on Stack Overflow - Search for 'Stack Overflow'
I just started using C# and I've got a couple of issues. I hook several controls to one event handler as in the following and I want to perform a slightly different action for each control: Private Sub Button_Click(sender as Object, e as EventArgs) _ Handles button1.Click, Button2.Click 'do… >>> More
SQL Server, Select CASE with different casting

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to do a select that do a cast only for a specific ID but it doesn't seems to work. Example : SELECT CASE WHEN(@ID <> 1) THEN Code WHEN(@ID = 1) THEN Cast(Code AS int) END Code FROM .... Any Idea ? >>> More