Touche! I should've put my brain in gear before hitting the keyboard.
Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 _____ From: Rachael Malberg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 4:10 PM To: [email protected] Subject: [RBASE-L] - RE: Odd data results... 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 <mailto:[EMAIL PROTECTED]> Mike To: RBASE-L Mailing List <mailto:[email protected]> 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] <mailto:[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?
