Type for COUNT() as VAR ?

Hello,

1. What type will NrInstances have in this query:

SELECT Module_ModuleType as LicProgPartID,'Module' as LicFor,COUNT(Module_ID) as NrInstances,Lic_RegCode FROM etc.

2) Can I force it to be NUMBER(10,0) for instance?

Thanks
Jan Received on Fri Nov 25 2005 - 02:58:47 CST