data type help

[svoec]

hey all

I need a field that I need to be 4 numbers --

for example, if the number is 6, it should be 0006 --

I can't find a datatype that wont trunc all my zero's (unless it is varchar, or text)

do you guys know of anything ???

thanks!

[superwormy]

I would use INT(4) and pad it with zeros with PHP when you pull from database...