Is there a way to not care about periods while searching in sql database

Viewed 85

Im working on a C#.net project where there is an issue while searching for a record in the database by the gmail Considering gmail doesn't care about periods, I need to search at the database for the needed email and hitting a result if in contained periods or not.

Code looks something like this:

Result = 
_dbContext.results
.Include(x => 
x.ResultArea)
.Include(x => x.ResultRoles)
.Where(x => x.emaiAddress == 
gmailAddress).FirstOrDefault();
0 Answers
Related