Greetings Friends,
This is probably old news to a lot of people, but I'm so happy I figured this out that I wanted to share this.
I have been working on a query to find EmplID from a private loan application. The loan application contains all of the PII I need to complete the search.
After converting date of birth from a character field using CCYYMMDD to MM/DD/CCYY using an expression, everything was working fine joining the expression to the date field, but I knew that wasn't nearly a good enough match.
I wanted to add a join on last Last Name. Both fields are character fields, so everything should be fine...but nope! I got 0 rows returned.
After a few minutes looking like a confused puppy, I took another look at the Fields tab in Query Manager. The Last Name fields were, indeed, both character fields, but one is 30 characters long and the other is 35 characters long.
On a whim, I created an expression for the shorter last name field to create one 35 characters long, joined on the expression, and it worked!
Here's a screenshot of the expression:
Thanks for listening!
Cheers,
Jessica
------------------------------
Jessica Holler
Systems Integration Analyst
DePaul University
jshisler@depaul.edu------------------------------