Look at SET EXACT ON/OFF

>I have the following test ,cant understand it... it must be a bug
>
>Select MYFILE (20 records on file)
>Replace All Myfield with Space(1)
>
>Select * from Myfile where Myfield <> 'ABC'
>.... returns 20 records
>
>Select * from Myfile where Alltrim(Myfield) <> 'ABC'
>.... returns zero records
>
>Can anybody explain this .
>
>Regards,
>
>Gerard