VFP9
The following SQL returns an empty result set. The prop_type is two spaces. When I am in the command window, both of the SQL Where clauses return .T. when the property record pointer is on the 00011987 key. but when I run the SQL an empty result set is returned. Why?
Select * FROM property WHERE key = '00011987' and;
alltrim(upper(prop_type)) != '04'