combine 2 columns in sql table to search for full names JPA
<p>I have entity where I have fisrtName and lastname but in search I need to implement search for fullName. How can I combine this two fields in search in JPA</p>

<p>right now I have something like this:</p>

<pre><code>Query query = em.createQuery("SELECT u from Client u where u.firstName like :firstName   or u.lastName like :lastName or u.documentID like :documentID");
</code></pre>

<p>I guess it is very commonly used feature but I don't know how to do that. Please help</p>