I am doing a select like this:
SELECT * FROM TABLE WHERE ALLTRIM(TRCODE) = "103"
and I get results that include empty TRCODE values (Character 6).
If I check at the same time ?ALLTRIM(SPACE(6)) = "103" it returns .F. as I would expect.
Why is the select picking up these records?
following SET's are:
SET EXACT ON
SET ANSI OFF
SET NEAR OFF
- Craig
"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson