GROUP BY inhibiting case-sensitivity

[raa44634]

I need to link two tables where case sensivity is essential. The query executes properly using the following SQL:

SELECT StrComp(tblCode!code,tblCodeRevenue!RevenueCode,0) AS Expr1, tblCode.code, tblCodeRevenue.RevenueAmt
FROM tblCode LEFT JOIN tblCodeRevenue ON tblCode.code = tblCodeRevenue.RevenueCode
WHERE (((StrComp([tblCode]!

,[tblCodeRevenue]![RevenueCode],0))=0))

However, when I enter GROUP BY case-sensitivity fails.  

Does anyone know how to maintain case-sensitivity when using GROUP BY?

Thanks!
- tony -

 

[BobJacksonNCI]

Take a look at the Option Compare instruction.



HTH,
Bob