fromaddr_l<> 0 and MOD (" fromaddr_l ", 2) = 1 AND toaddr_l <> 0 and MOD (" toaddr_l", 2) = 1. Field type is Text.
Sounds reasonable doesn't it? The modulo operator (MOD) can only be applied to integer values.
CAST(exp AS data_type)
See: SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop