[RBASE-L] - Odd data results...

[Rachael Malberg]

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?