why do i find this "|Type ID: (SQL &" on the columndatatype. I use the cloudscape 1.7.2 and I invoke this statement :
select c.columnname,c.columndatatype from sys.syscolumns c,sys.systables t where c.referenceid=t.tableid and t.tablename='AccountBeanTable';
can anyone help me with it? I need an answer as soon as possible as I'm running out of time for my final assignment. thx

t00nz