Bill - I get every record in the table:
With vtest set at text '00051334944' SELECT Claim#, (CALL KeepNum(Claim#)) + FROM Assigned + WHERE (call keepnum(Claim#)) = .vtest Gives me: Claim# (CALL(KeepNum(Claim#)) ------------- ---------------------------- J26059001 26059001 200DSSB02930 20002930 00-051-334944 00051334944 etc Can you NOT do a CALL statement in a WHERE clause? I created this select statement as a view, giving a name to the CALL statement: CREATE VIEW testvw AS+ SELECT Claim#,(CALL(KeepNum(Claim#)) AS `KeepNumVal` FROM Assigned Then I could do: SELECT * FROM testvw WHERE KeepNumVal = .vtest It seems to work, but it takes forever because it's looking thru every row in the table. I guess I could project a temp table from the view and build an index on it ... I may have to bite the bullet and take that first piece of advice from Troy and get that DLL from Larry - except that you've worked so hard on it ... : ( Sami ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 4:57 PM Subject: Re: Removing blank from data > 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/ > > > ================================================ 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/
