Solved

Truncated incorrect DOUBLE value: 'FIL1385'

Posted on 2008-10-08
3
481 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:kingjely
3 Comments
 
LVL 82

Accepted Solution

by:
hielo earned 500 total points
ID: 22675689
try:
SELECT 
	p.`BrandNumber` as `Brand`,
	p.`PoNumber` as `PO NUMBER`,
	p.`StyleCode` as `STYLE`,
	p.`InvoiceNumber`,
	p.`Description` as `DESC`,
	p.`SeasName`
FROM 
	purchaseorder p
WHERE 
	left(p.`SeasName`,4) = 'S8-k'
AND
	(
		(p.`InvoiceNumber` between 'IND1278' and 'IND1583') 
	OR
		(p.`InvoiceNumber` between 'FIL1385' and 'FIL1696')
	)

Open in new window

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question