Skip to Content
0
Former Member
Jul 21, 2008 at 05:43 PM

Case Matching

28 Views

I am designing a report using an external data source through ODBC and connecting to a database. The goal is to do a match on names. The external data source is an Excel spreadsheet with names in CAPS. And I am matching to a database with names in both CAPS and Mixed Case. When I link the tables, I only match to the uppercase names. I have tried the UCASE functions on both the Excel side and the database side. Database is case-insensitive is checked off. Can anyone help?