https://api-prod.corelogic.com/trestle/odata/Property?$filter=cast(StreetNumberNumeric, 'Edm.String') ne '1500' and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,StreetNumberNumeric
The cast function has the following signatures: type cast(type) and type cast(expression,type). The single parameter cast function returns the current instance cast to the type specified. The two parameter cast function returns the object referred to by the expression cast to the type specified.