I appreciate the help. I will try your suggested query, and update.

Im going to do a little research on colesce, as ive never used it. So that code will pull their transcript seq 002 record IF they have one, and if...

still looking for an answer to the trans seq question, anyone?

One more thing i need to add...On their transcript gpa record, when it is pulling t.earned credits, their is also a trans seq number of either 001 or 002. Not...

After further review it looks like that by adding those as a left outer join by using

on p.people_code_id=t.people_code_id

and t.record_type='O'

and t.academic_term='Fall'

and t.academic_year='2007'

its pulling IF they have a fall 2007...

Thanks!! It worked. Now i see the people who were previosuly missing. Ive never seen a join created like this, can you explain how exactly this is working? Im looking...

Can you clarify? Im not sure how to move them to the on line. The joins confuses me? Can you write an example?

So the key is when joining the table containing the transcript seq to use the max clause? I.e. this will pull trans 2 IF avaialable, if not trans 1?

The ssn im looking for have ONLY 3 digits, not the full 9. So i dont need to liook further than the first three digits?

Thanks Daryl. That is what i did. I noticed that even just joining the first name field i got NO results. After further investigation, i noticed for some reason their...

luckily there were only about 50, and i just removed them by hand. Everything works now, thanks for the insight guys!!

weird, i wonder how that could have been added to this file.

Found it!! When i looked at the actual table values using enterprise manager, i noticed all the records that were appearing in correctly had something like this

P000008269**

P000008270**

But the *...

Kenneth Fisher (10/12/2007)

---

Its possible you have some weird ascii character that may be invisible but still there. Its an unusual thing to have happen but it does happen. ...

Tried select * from upload where RTRIM(people_code_id) ='P000008270'

and still returned zero results, im going to break my original upload file into 3 smaller files, and reupload. Any other ideas...