A very warm New Year to you too (and hopefully not because of global warming 🙂

Are you asking to do something like this?

Select * from

table1 join table2 on whatever

Where LCASE(table1.LastName) = LCASE(table2.LastName)?

This would be "connection specific".