I have a following statement that places '0's in front of the amount make it total 27 characters
select RIGHT('00000000000000000000000' + convert(varchar, CAST((amount) AS numeric(23,3)),27) , 27)
The positive amount should look like this
But if the amount is negative , I would like to palce the (-) sign to the left of the number
How can I do this?