On Tue, Nov 18, 2008 at 05:51:08PM +0000, Raymond O'Donnell wrote: > You could use a regular expression in substring() to get just the > numeric bits. Thanks, never noticed that substring would accept a regexp before. Syntax is a bit baroque, but it seems to work! Sam -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general