> How can I count the number of columns in a table using an "ij" You could query the system catalogs. Something like: select count(*) from SYS.SYSTABLES, SYS.SYSCOLUMNS where SYS.SYSTABLES.TABLEID=SYS.SYSCOLUMNS.REFERENCEID and SYS.SYSTABLES.TABLENAME = 'MY-TABLE-NAME'; thanks, bryan