From a database of student results I am running a query showing student-wise sum of marks in all subjects. In the same query I would like to include a column with an expression to show the student-wise total of marks in those subjects which do not end with the text :"Lab". How do I get that ? I tried using function DSum but not getting the desired results. Pl help