Any function to let me know how many rows that I updated after UPDATE SQL statment? Just like @@rowcount (MS SQL). I always compare with MS SQL becuase I used MS SQL most. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]