Or you could try | SELECT count(a) FROM TableA | (untested) Regards Felix View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4074694#4074694 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4074694