.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Case insensitive string comparison using Like

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Windows Application

Consider this code;


		Dim Var1, Var2 As String

		Var1 = "TEST"
		Var2 = "es"

		If Var1 Like "*" & Var2 & "*" Then
			'No Match
		End If


It returns no match because it is case sensitive. I need it to return a match (so case insensitive) and it needs to be fast because i am using it to filter records on the fly as the user types. Using .ToLower is slow when you are dealing with 1000's of repetitions.

Is there a more efficient way to do what i want without the performance penalties of converting them both to lower case every time?

String.Compare doesnt seem to cater for it.

View Complete Post

More Related Resource Links

Get Public String in HTML doesn´t work in this case?

Hi, I am trying to retreive a public String in code behind in the HTML code like below but the compiler says that there is Illegal characters in path. I wonder if it is possible to pass a public String here in this case like this ?  <%@ Page Language="C#" ValidateRequest="false" AutoEventWireup="true" CodeFile="Hello.aspx.cs" Inherits="Hello" %> <%@ PreviousPageType VirtualPath="<%# previousURL%>" %> (code behind): public String previousURL = "someURL";  

string comparison in ssis2008?


hi all,

i was shocked by the fact that "9:9" < "99" returns true in the Derived Column component in ssis 2008.

what did i misconstrue?


Andrew Chen
Interested in BI related technologies

Pondering ASCII ordering in a string comparison



The following query on SQL Server:

Select case when '9:9' < '99' then 1 else 0 end
returns 1

Given, according to http://asciitable.com/ ':' comes after '9' I am surprised that the above query does what it does. Then again I'm clearly making a wrong assumption somewhere.

Can anyone explain this?




http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Jamie Thomson

String.Equals() returns FALSE in case of two same string


Hi People,

I have the following piece of code



(SakerhetsKod.ToString().Equals("muris")) where my problem is in method SakerhetsKod.ToString().Equals("muris") that always returns false although i

How do I use a case-insensitive collation in SQL 2008?


I am testing Configuration Manager 2012 Beta 2 and there is a requiement for SQL:

You must use a case-insensitive collation (e.g. SQL_Latin1_General_CP1_CI_AS) and it must be consistent throughout your hierarchy

I wanted to find out step by step how and when I am to set this in SQL. I am not a DBA so it is not very clear to me how to do this.

Thanks, Brit



Visual Case Tool - UML Tutorial

The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.

Use Case Diagram

The use case diagram shows the functionality of the system from an outside-in viewpoint.

Actors (stick men) are anything outside the system that interacts with the system.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Connection String

We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!

Built-in Functions - String Functions

String functions let you extract various portions of character strings, change the case of strings, concatenate and reverse strings and perform many other types of manipulations. All built-in string functions are deterministic with the exception of CHARINDEX and PATINDEX

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

highlight string


i am looking for a function that takes two string parameters 

str1 = "hello how are you today mr john"

str2 = "how today"

and in return it shoud highlight the words "how" and "today".

Any ides? I prefer if its possible using reg expression...Thanks

Could some one tell me whats the Problem with this String Manipulation ??? C#.net



I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????

extract picture data from a string


dears,advance thanks.can anybdy help to solve my problem which is describing below.

Example- %%D1,100,0,0004[data...][0d0a]

Head - %%D1
Amount of data package -100
The data package No. - 0
Data Length -1024 (0004 (low bit in front, high bit in back) 0004= 0x0400=1024;)

data- Original Picture data -1024(maximum)
Tail -0x0d0a
Data in hex

from the above example i want to extract picture data and need to store in to the sql table.sql table columname is image and datatype is also image.after that i wanted to display this image column to an aspx page.

expecting help asap.

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

WebMatrix conversion failed when converting from a character string to uniqueidentifier?


I am trying to retrieve xml from a small function in my .cshtml page. Its throwing me an error. This however, runs fine in a console/form environment.

It takes 3 parameters and 1 exception.

myDll.GetXML(year, username, uniqueidentifier, out ex);

When I run this page I get the error, "Conversion failed when converting from a character string to uniqueidentifier."

Or a stack of.

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBeha
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend