Roland Martin wrote: > I have a need to filter the result set before aggregate functions are > performed.
Use the WHERE clause. > Unfortunately I cannot query the security system to find out all valid > values and add these values to the where clause. I have to give a value to > the security system and it returns pass or fail. Add a call to a user-defined function to the WHERE clause. <http://www.sqlite.org/c3ref/create_function.html> Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users