Newbie question

I have built a database and VB.net app and it's working great...
The question is how to accomplish that number 1 is shown like this 0001
(with zeros in front) in the databse.
Thanks.That's really a job for the front-end. However, you can try:
select
replace (str (MyCol, 4), ' ', '0')
from
MyTable
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Morx" <morx@.gawab.com> wrote in message news:cgche5$lv4$1@.ls219.htnet.hr...
I have built a database and VB.net app and it's working great...
The question is how to accomplish that number 1 is shown like this 0001
(with zeros in front) in the databse.
Thanks.