Truncated incorrect DOUBLE value: 'FIL1385'
Posted on 2008-10-08
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?
Do you think my 'InvoiceNumber' syntax is the problem?.