<div dir="ltr"><div>Hello Alan,<br><br></div>Yes it is<br>SELECT * FROM Contacts WHERE email <a href="mailto:like%27%25@gmail.com">like'%@gmail.com</a>%'";<br><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">Christophe Humbert<br><br></div></div>
<br><div class="gmail_quote">On Wed, May 20, 2015 at 8:28 AM, Alan Lord <span dir="ltr"><<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 19/05/15 20:16, Christophe Humbert wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
SELECT * FROM Accounts WHERE accountname like'%Demo%'";<br>
</blockquote>
<br></span>
What's your query for Contacts then? It has different fields...<br>
<br>
e.g.<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
SELECT * FROM Contacts WHERE lastname like'%Smith%'";<br>
</blockquote>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div></div>