Resolved! Unexpected results on where statement
I'm a bit baffled by the fact that even though I specifically say I do not want to see records with a tblAssetCustom.Custom2 field like %retired%, I still get items with "Retired" in that field. Here's the report:Select Top 1000000 tblAssets.AssetID,...