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]