× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.