The agency I work for is embarking on a Computer Assisted Dispatch (the other CAD) migration. I've noticed that the current CAD software as well as the new CAD software type the address range (Left From, Right From, Left To, Right To) fields for centerline data typed as Text/Character.
I asked the current CAD vendor about this move and the reply was 'Many of our agencies store letters with the house number, so that is why address ranges and house numbers are stored as strings...' Okay; I can buy an address field in a point feature class being a string to accommodate a suite or apartment designator, but in a range? I'm at a loss.
Please let me know if you deploy characters in you address range fields.