Rachel, what happens if you run: Where ContactTypeID='1' and CMvLname Like 'sche%'
Also is ContactTypeID a TEXT datatype or an INTEGER datatype Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Thu, 8/14/08, Rachael Malberg <[EMAIL PROTECTED]> wrote: > From: Rachael Malberg <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Odd data results... > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, August 14, 2008, 2:42 PM > Okay my SQL statement doesn't return all my records and > can't figure why... > > When I run the following at the rprompt > R>select > CID,CMvFname,CMvLname,ContactTypeID,ContactTypeStatus from > atvGetContMstrType Where CMvLname Like 'sche%' > > I get.... > 1 MORGAN SCHEDIN > 0 A > 1 MORGAN SCHEDIN > 1 A > 74 CHRISTINE SCHEDIN > 0 A > 1741 KEITH SCHEURING > 0 A > 1741 KEITH SCHEURING > 1 A > 2310 ROBERTA SCHEDINE > 0 A > 2310 ROBERTA SCHEDINE > 9 A > 2578 DENNIS SCHERER > 0 A > 2578 DENNIS SCHERER > 3 A > 3673 MIKE SCHENDZIELOS > 0 A > 3673 MIKE SCHENDZIELOS > 1 A > 1741 KEITH SCHEURING > 0 A > 2310 ROBERTA SCHEDINE > 0 A > 2578 DENNIS SCHERER > 0 A > 3673 MIKE SCHENDZIELOS > 0 A > > then I run this... > R>select > CID,CMvFname,CMvLname,ContactTypeID,ContactTypeStatus from > atvGetContMstrType Where CMvLname Like 'sche%' and > ContactTypeID='1' > > and get these... > 1741 KEITH SCHEURING > 1 A > 3673 MIKE SCHENDZIELOS > 1 A > > but not this one... > 1 MORGAN SCHEDIN > 1 A > > any ideas why?
