JOIN ignores lower vs upper case

[Ross Nixon]

I was joining two tables with unique row identifiers.

The problem was that these were 'case sensitive'
I did not want CA_1 to join to ca_1

Is there a way to force the 'case' to be taken into account?

Thanks

Ross