well I thought that might be it but if it was they wouldn't have been returned in the first results ----- Original Message ----- From: Ramsour Mike To: RBASE-L Mailing List Sent: Thursday, August 14, 2008 2:47 PM Subject: [RBASE-L] - RE: Odd data results...
Rachel: Have you tried CMvLname LIKE '%sche%' in case there's a space at the beginning of CMvLname? Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 ------------------------------------------------------------------------------ From: Rachael Malberg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 3:43 PM To: [email protected] 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?
