Hi, if I have a sql like this: select distinct FirstName from student_info order by FirstName and I am using a CMP, how to write the <finder> in jaw.xml? Thanks a lot! _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user