Hi Satheesh, Thank you for your quick response.
It works pretty good. :) wolfgang > > If you add a cast to 'columndatatype', you can achieve > the'minimumDisplayWidth' like functionality. > > ij> select columnname, cast(columndatatype as char(20))from sys.syscolumns > where > referenceid in (select tableid from sys.systables a, > sys.sysschemas b where a.schemaid=b.schemaid and b.schemaname='APP' > and a.tablename='MYTABLE'); > COLUMNNAME > |2 > -------------------------------------------------------------------------------- > --------------------------------------------------------------------- > MY_COUNTER > |INTEGER NOT NULL > > 1 row selected > > Satheesh __________________________________ For All Sports Fans! http://pr.mail.yahoo.co.jp/yells/
