>But, if you include the city, state and zip on the next line, ie. [1312 S Caom St E Suite A10] + CHR(13) + [City, State Zip], it handles it just fine.
>
>The one thing it doesn't seem to handle very well is separating out PO Boxes from street addresses.
>
>Regards,
It doesn't break street to pieces as Tracy requires. It's not an easy task without supporting lookup tables.
Try it with [1312 S Caom St E Suite A10] + CHR(13) + [Kew Gardens, NY, 11415]
If it's not broken, fix it until it is.
My Blog