I have two columns in separate table that contain names. My problem is that the cases differ, for instance the name
"John Cooper" in the one column ad in the second table it may appear as "JOHN COOPER". What SQL code would I use to ignore case sensitivity. I am currently using the following code:
sSQL = "Select Distinct [LINK ID] From [BANK] Where [DESCRIPTION] = '" & oBankDescription & "'