Rachael is the datatype for TypeID Text or Integer? It looks like Text based on your second sql statement. I would see if there is a space in front of the 1. The results would suggest the data could be different for the Type ID for the one not included. Gary
----- Original Message ---- From: Rachael Malberg <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, August 14, 2008 2:42:43 PM Subject: [RBASE-L] - Odd data results... 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?
