How can the query results include null if it's a required field on the front end?

Sorry the question is vague. Are you sure the data exists in the table? Are you using some kind of outer join sysntax? If yes, then it will return NULL values if it cant find matches.

If this is not what you were asked please elaborate on the issue

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page