Sami, What do you get with
SELECT Claim#, (CALL KeepNum(Claim#)) + FROM Assigned + WHERE (call keepnum(Claim#)) = .vtest and other similar variations: WHERE (call keepnum(claim#)) <> claim# Bill On Tue, 11 Jun 2002 16:17:39 -0500, Sami Aaron wrote: >SELECT Claim# FROM Assigned WHERE (call KeepNum(Claim#)) = .vtest > >should return the same list of values as above. > >The way you posted it (with the two corrections) the SELECT COUNT(*) >statement is returning a count of ALL the rows in the table. > >Am I just not understanding what should be returned? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
