C# Version Of SQL LIKE

by

Regular expressions allow for everything that LIKE allows for, and much more, but have a completely different syntax. However, since the rules for LIKE are so simple(where % means zero-or-more characters and _ means one character), and both LIKE arguments and regular expressions are expressed in strings, we can create a regular expression that takes a LIKE argument (e.g. abc_ef% *usd) and turn it into the equivalent regular expression (e.g. \Aabc.ef.* \*usd\z):

@"\A" + new Regex(@"\.|\$|\^|\{|\[|\(|\||\)|\*|\+|\?|\\").Replace(toFind, ch => @"\" + ch).Replace('_', '.').Replace("%", ".*") + @"\z"

From that we can build a Like() method:

public static class MyStringExtensions
{
  public static bool Like(this string toSearch, string toFind)
  {
    return new Regex(@"\A" + new Regex(@"\.|\$|\^|\{|\[|\(|\||\)|\*|\+|\?|\\").Replace(toFind, ch => @"\" + ch).Replace('_', '.').Replace("%", ".*") + @"\z", RegexOptions.Singleline).IsMatch(toSearch);
  }
}

And hence:

bool willBeTrue = "abcdefg".Like("abcd_fg");
bool willAlsoBeTrue = "abcdefg".Like("ab%f%");
bool willBeFalse = "abcdefghi".Like("abcd_fg");

More Related Contents:

  1. What is the difference between String and string in C#?
  2. Why .NET String is immutable? [duplicate]
  3. What is the difference between String and string in C#?
  4. Read SQL Table into C# DataTable
  5. Unrecognized escape sequence for path string containing backslashes
  6. Finding all positions of substring in a larger string in C#
  7. Splitting a string / number every Nth Character / Number?
  8. Check if a value is in an array (C#)
  9. Is String.Contains() faster than String.IndexOf()?
  10. Is there an alternative to string.Replace that is case-insensitive?
  11. How the StringBuilder class is implemented? Does it internally create new string objects each time we append?
  12. How is GetHashCode() of C# string implemented?
  13. C# testing to see if a string is an integer?
  14. Need to perform Wildcard (*,?, etc) search on a string using Regex
  15. Is String a primitive type?
  16. string.IsNullOrEmpty(string) vs. string.IsNullOrWhiteSpace(string)
  17. How to know the size of the string in bytes?
  18. IEnumerable to string [duplicate]
  19. Code to validate SQL Scripts
  20. If strings are immutable in .NET, then why does Substring take O(n) time?
  21. string.ToLower() and string.ToLowerInvariant()
  22. SqlConnection.Close() inside using statement
  23. How to do ToString for a possibly null object?
  24. String.Format – how it works and how to implement custom formatstrings
  25. Converting String To Float in C#
  26. Does String.GetHashCode consider the full string or only part of it?
  27. Passing datatable to a stored procedure
  28. Convert String^ in c# to CString in c++/CLI
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment