I have a table which holds both negative and positive integers for a particular column and the column can accomodate any no. of integers.

I would like to lpad the first 10 numbers.
I can get my expected result for the positive integer.
But for the negative integer, I will get my result has '****-12345', if used lpad(dno,10,'*')
which is not the expected output.
The o/p should be similar to '-****12345'.
How can I achieve it.

Thanks in advance.
Question asked by visitor karthick