Looking for an SQL to append leading zeros

Hi
  select FIELD2  from FILE  where FIELD1 IN ('NYC1','NYC2')          
 
The result is
  ------------
78968
5674
330
376543 
  --------------------------------
  FIELD2 is defined as max length of 10 digits.   
  when I run above SQL it gives some rows  as shown above where FIELD2 values 
are less than 10 digits.
Wherever the value of FIELD2 is less than 10 digits , I want to add leading 
zeroes to make it 10 digit number.
  for eg if   FIELD2 of above SQL is 78968
I want to make it as 0000078968 (making it as total 10 digit value).
The result should be as below
  0000078968
0000005674
0000000330
0000376543
 
  Greatly appreciate your help...


Thanks,

Donna.
 
---------------------------------
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.