Casting from varchar to numeric

From: Tom Ansley <tansley(at)law(dot)du(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Casting from varchar to numeric
Date: 2002-05-16 15:48:47
Message-ID: 200205160948.47196.tansley@law.du.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

Is there a way of casting from a varchar to a numeric type?

My problem consists of a varchar(10) that are all numeric. They are telephone
numbers and I want to convert them during a select statement to (XXX)
XXX-XXXX

Anybody have any ideas?

Thanks

Tom

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Erickson 2002-05-16 15:56:46 Re: Answering my own question
Previous Message gerry.smit 2002-05-16 14:39:55 Re: Answering my own question