<div>
<div class="content wysiwyg-content">
SELECT p.`BrandNumber` as &quot;Brand&quot;,<br />
p.`PoNumber` as &quot;PO NUMBER&quot;,<br />
p.`InvoiceNumber` between 'IND1278' and 'IND1583' or 'FIL1385' and 'FIL1696',<br />
p.`StyleCode` as &quot;STYLE&quot;,<br />
p.`Description` as &quot;DESC&quot;,<br />
p.`SeasName` = &nbsp;left(p.`SeasName`,4) = 'S8-k'<br />
FROM purchaseorder p;<br />
<br />
&quot;error Truncated incorrect DOUBLE value: 'FIL1385'&quot; &lt;=== this to me is a shortened , incorrect, whole number? &nbsp;<br />
<br />
Any ideas?<br />
Do you think my 'InvoiceNumber' syntax is the problem?.<br />
<br />
Sorry, thanks.<br />

</div>
</div>


SELECT p.`BrandNumber` as "Brand",
p.`PoNumber` as "PO NUMBER",
p.`InvoiceNumber` between 'IND1278' and 'IND1583' or 'FIL1385' and 'FIL1696',
p.`StyleCode` as "STYLE",
p.`Description` as "DESC",
p.`SeasName` =  left(p.`SeasName`,4) = 'S8-k'
FROM purchaseorder p;

"error Truncated incorrect DOUBLE value: 'FIL1385'" <=== this to me is a shortened , incorrect, whole number?  

Any ideas?
Do you think my 'InvoiceNumber' syntax is the problem?.

Sorry, thanks.


Truncated incorrect DOUBLE value: 'FIL1385'

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.