appending zeros on the leftside of the field
The reciever side field must always be sent 10 digits
the source side, there can be 2 or 3 or 4 ... less than 10
so dynamically I hav to append rest of the zeroes on the left side to as to make the total digits to 10
can someone provide me with udf to do this?
thanks in advance ,
Use the <b>Format Number</b> standard function and specify the format as 0000000000.