Hi all, Is it possible to get the number of rows in a resultset using SQL? If I execute a statement like: SELECT COUNT(*) FROM table1 WHERE ID=12, I dont know how to assign the result to an integer... Thanx, WJ
