No, unfortunately it does not. The way this is going, I may just have to have another sql statement before this on that grabs all students that are not inactive and continue with the result table.
Thanks for the help.
Beth
>
>Beth,
>Considering "inactive" casing is right in your code, might it be that returned rows with "INACTIVE" are something like [whitespace or nonprintablechar]+"INACTIVE"?
>(or with set ansi on after INACTIVE has chars that's not a space).
>
>Does
!(ltrim(stu.enrollment_status) == 'INACTIVE')
help?
>Cetin