Hi John,

good morning. I just wanted to touch base with you this morning. I have been able to solve my own puzzle after I did some extensive...

Thanks John. I appreciate the link as well. I will from now use that as a guide whenever I post any T-SQL statements.

sample data

Student ID ...

Okay....when you run the query it shows all students that have a grade of either(F-same as fail but interpreted differently by the users),FAIL,WF,WD,I,DP,DF. These are all grades a student...

I have a question....The script is showing all students with either F,FAIL,WD,WF,I but I only want them to show if they have at least an F.