Tom Deprez writes: > ... optional tests and optional paramters in Z SQL methods ... The "where" of "dtml-group" will generate a "where" keyword, if the enclosed query is not empty. However, you must pass the declared parameters whether or not you use them. You can provide default values, though. The syntax is parameter="" to give "parameter" the empty string as default value. Dieter