Robert,

> > All expressions generate column names on which I would never count.
> > I always use an alias if I need to impose a name (and I always need).
> > BTW, what should it return? Should it use "ZIP" as the column name?
>
> Yes. If was going to call it something without my designating an
> alias, ZIP is much more logical than substr.

No, it's not. :-)
The returned value is much more a "substr" than a zip code.
"Zip code excerpt" would perhaps be a logical name.
Ciao :-)
--
____
_/\/ando