Yes, it does... Only "AS Count" won't work, because COUNT is a name of a function (in fact, you're using it)... So, SELECT COUNT(*) AS C FROM table works... and SELECT COUNT(*) AS Records FROM table works... Cheers, Arkadiy Does the following query work in Sybase: select count(*) as count, * from table