you can use:
sprintf('%.10f', yourNumber)
Or a more complicated option is to use Java-based formatting ( see additional information , Yair Altman credit for showing this method), for example:
char(java.text.DecimalFormat('#.00000000').format(yourNumber));
source share