Error description: Object reference not set to an instance of an objec

Hello,
This is a wierd one. I have a table and a view that is having this issue and I'm wondering if you have seen it before. I get this message on the list.aspx page and I have narrowed the issue to the sql statement and it only happens when the "order by" is "DESC". The "order by" works fine, the "ASC" works fine, but the "DESC" gives me errors. I have other tables and views with "DESC", but for some reason, they do not get this error message. The SQL is fine and runs fine by itself, it just doesn't work with asp.net on certain ones.
Thanks for your continued support!