nm ... I found the problem ... I need to use BINARY(LPAD ...)
-----Original Message-----
From: Rob Brooks [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 10:04 AM
To: mysql@lists.mysql.com
Subject: Query Error Help
Hello, I have this query:
SELECT FL3_PatientControlNumber, claims.RecordKey as reckey,
FL1_ProviderName, CalcFlag
FROM claims INNER JOIN service_line ON service_line.ClaimKey =
claims.RecordKey
WHERE ( service_line.FL42_ServiceLineRevCode BETWEEN LPAD('110',4,'0') AND
LPAD('210',4,'0' ) ) ORDER BY FL3_PatientControlNumber
which returns this error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT),
(utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation
'between'
and am confused as to what's going on with this?
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
