zeroes not being retrieved from varchar col

[peppericious]

For mobile phone numbers, I have 2 varchar cols, 'prefix' and 'suffix' which contain numbers like:

 

'083'

'085'

'087'

 

.. and:

 

'1234567'

'2345678'

'0987654'

 

... respectively. Now, when I run a select query like:

 

SELECT CONCAT(prefix, '-', suffix) AS mobile FROM table

 

... I'm getting results like:

 

83-1234567

85-2345678

87-987654

 

How can I modify my query so that the '0's (zeroes) are not omitted from the results?

 

TIA.

[requinix]

Are you absolutely sure they're VARCHAR columns and have that they the correct data?

[peppericious]

Yes, both varchar columns. When I view the data in phpMyAdmin, it's all there, zeroes included.

[peppericious]

... sorry requinix, I have resolved this. The query is working now. I think I may not have uploaded my latest query script when I posted initially.... duh.

 

Thx for your help in any case.