leading 0 for numeric fields
Jonathan Mangin wrote:
- Original Message -
From: George Law [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
Sent: Wednesday, August 09, 2006 3:40 PM
Subject: forcing leading 0 for numeric fields
Hello All,
I have what is probably
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
- Original Message -
From: George Law [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
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 numbers, broken
Jonathan Mangin wrote:
- Original Message -
From: George Law [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
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