Mei,
try
cast(count(*) as decimal(18,0))
or
sum(cast(1 as decimal(18,0)))
Kind regards
Ulrich
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2003 Indexes