Leslie, thanks for getting back so quickly on this. I tried to respond to you immediately yesterday but the system was experiencing problems. In answer to your questions of yesterday:
1. The fields are in different tables.
2. The fields are both text fields.
3. UIC2 will always be a single value. I'm looking all records of UIC1 that match UIC2 e.g.,
Table1: UIC1 SSN
W12345 987654321
UIC2 SSN
Table2: 12345 445665444
SELECT UIC1, SSN FROM TABLE1 WHERE UIC1 = '12345';
I know this is confusing, but it's the best I can describe what I'm trying to do.
V/r,
Gregg