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
