gt;>>Cc: George Law; MYSQL General List
>>>Subject: Re: forcing leading 0 for numeric fields
>>>
>>>Jonathan Mangin wrote:
>>>> - Original Message -
>>>> From: "George Law" <[EMAIL PROTECTED]>
>>>>
Jonathan Mangin wrote:
- Original Message -
From: "George Law" <[EMAIL PROTECTED]>
To: "MYSQL General List"
Sent: Wednesday, August 09, 2006 3:40 PM
Subject: forcing leading 0 for numeric fields
Hello All,
I have what is probably a simple question.
I hav
- Original Message -
From: "George Law" <[EMAIL PROTECTED]>
To: "MYSQL General List"
Sent: Wednesday, August 09, 2006 3:40 PM
Subject: forcing leading 0 for numeric fields
Hello All,
I have what is probably a simple question.
I have a table of phone nu
Hello All,
I have what is probably a simple question.
I have a table of phone numbers, broken into npa,nxx,station
So, 8001231234npa =800 nxx=123 station=1234
Some queries pull data from this table in the format:
select * from table where concat(npa,nxx,station)=8001231234
That is