hi,
does anyone know if there exists a Postgres function to extract the integer
portion of a text string?
e.g.
somefunc('109PL') --> 109
somefunc('Plot Number 106') --> 106
TIA,
ben
--
ben ausden
developer, navyblue new media
[t] 0131 553 0100
[f] 0131 553 1303
[e] benedict{at}navyblue.com