Escape an Underscore Like cause

if you search about Underscore this query will not get a true value

   Where Username Like '%_d'
   Where Username Like '%_d' 
  1. <code>
  2. Where Username Like '%_d'
  3. </code>
<code>
   Where Username Like '%_d'
</code> 
so you need to use :

   Where Username LIKE '%[_]d'
   Where Username LIKE '%[_]d'
  1. <code>
  2. Where Username LIKE '%[_]d'
  3. </code>
<code>
   Where Username LIKE '%[_]d'
</code>

Popular posts from this blog

Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=xx.0.0.0, Culture=neutral, PublicKeyToken='xxx' or one of its dependencies.

C# Crop white space from around the image

The specified version string contains wildcards, which are not compatible with determinism.