I'm not sure if this can even be done, but if it can, I'm sure it involves SQL commands that are way over my head.

I'm using Crystal XI. I'm connecting an IPCC database (db_cra) and a Track_IT database (TRACKIT80_DATA2).

In db_cra, I have a field (ContactCallDetail.originatorDN) that contains the phone number for each call into our help desk (either as 7 digit Cisco numbers or normal 10 digit numbers, with no dashes)

In TRACKIT80_DATA2, I have a field (TIUSER.EMPLOYEE_ID) that contains Cisco numbers for our users that have them, and another field (TIUSER.PHONE) that contains normal phone numbers for users without Cisco numbers (this field DOES have dashes in the phone number).

I created a left outer join between ContactCallDetail.originatorDN and TIUSER.EMPLOYEE_ID, and that worked great. Now, when I check my call records, I can see the name of the person who called...but ONLY if they call using a Cisco number. So, here's where I get over my head.

Can I, first of all, link both TIUSER.EMPLOYEE_ID and TIUSER.PHONE to
ContactCallDetail.originatorDN, so if ContactCallDetail.originatorDN contains a 7 digit number, it will link to TIUSER.EMPLOYEE_ID , otherwise it will link to TIUSER.PHONE.

Now, to up the difficulty, TIUSER.PHONE contains dashes and ContactCallDetail.originatorDN does not. I suppose they could be linked according to the last 4 numbers in the field, but I'm not sure if that would work or how to even do it.

I like a challenge, but I'm swimming a bit deep for my level on this one. Anyone have some ideas to help me keep afloat?

Thanks!

I tried what you said and it worked perfectly! Thanks so much!