Raymond,
You could use a regular expression in substring() to get just the numeric bits.
Thank you. I do'nt have any experience on regex.Can you provide a sample how to use regex to get numeric substring from start of string ?
Andrus.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general