On Friday, March 14, 2003, at 04:43 PM, Stephan Szabo wrote:
> sszabo=# select lower(a) || to_char(b, '09999999999') from test;
> ?column?
> ----------------
> a 00000000123
> a1 00000000023
> (2 rows)
>
> (I guess you might really want FM0... but...)
FMO?
Thanks for the help!
David
--
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]