Re: phone number list

> It sounds as though you are storing the numbers in numeric fields, in
> which case store them in text fields instead.
>
> But you need to give much better information if you seriously want
> assistance.  That is, you need to show us the table structure and the
> commands by which you insert a row in that table.

I dropped the db and recreated the fields using varchar as Louise
suggested.  Here are the commands I'm using to create the tables:

 create table phonenumbers (
             areacode varchar(3),
             prefix varchar(3),
             suffix varchar(4)
             );

And here's the insert commands:

insert into phonenumbers values (425, 333, 4297);
insert into phonenumbers values (425, 333, 4031);
insert into phonenumbers values (425, 888, 3677);
insert into phonenumbers values (425, 888, 4324);
insert into phonenumbers values (425, 888, 0773);


And here's the results of select:

dncl=# select * from phonenumbers;
 areacode | prefix | suffix
----------+--------+--------
 425      | 333    | 4297
 425      | 333    | 4031
 425      | 888    | 3677
 425      | 888    | 4324
 425      | 888    | 773


Any ideas?  Do I need to change the format of the fields again?

--Bryan