Query on Table not filtering correctly

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a query where Select * from ApprovedList where ApprovedFld =
"Approved"
However even thought the record does contain "Approved" the record only
shows up if I change the code to "Select * from ApprovedList where
ApprovedFld is not null"
or "Select * from ApprovedList".

This is reqlly wierd
 
Back
Top