Consider this code;
Dim Var1, Var2 As String
Var1 = "TEST"
Var2 = "es"
If Var1 Like "*" & Var2 & "*" Then
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