>> AND answers.correct = 1 AND userAnswer AS <> NULL >> Its the last line that is giving me trouble it does not seem to like to filter on a >> alias.
I'm assuming you are referring to the And userAnswer AS <> NULL line, if that is the case, try a few different combinations of Is null, and not useranswer is null, and not useranswer = null, etc. ALso, it looks like you have the column name and 'as', but no name for it. i.e. you should remove the 'as' in the last line ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
