title: SQL RIGHT function equivalent in Entity framework Core
body: <p>I'm working with a Net Core project, using entity framework, mysql database and pomelo framework. I need to perform this query, in order to compare the last X characters of a property in my model, against a pattern:</p>
  
  <pre><code>_context.Cars
  .Where(c =&gt; EF.Functions.Like(c.CarName.ToString().Right(5), pattern))
  .ToList();
  </code></pre>
  
  <p>I want to know if there is any SQL RIGHT function equivalent in Entity framework Core.</p>
  
  <p>Thanks in advance</p>