locked
Handling decimal values in SQL RRS feed

  • Question

  • Hi Team, 

    We have a requirement Like this; 

    The decimal value will be displayed as follows: 

    1.50 (Given) = 000000015000 (Derived)

    Rule:

    - Do not include the decimal point
    - The format follows this structure $$$$$$$$cccc where $$$$$$$$ are the numbers to the left of the decimal point (with leading zeros) and the cccc are the numbers to the right of the decimal point (with trailing zeros)
    - Samples:
     1.50 = 000000015000

    Is there is any approach for this in SQL ?

    Thanks,

    Vikram 

    Wednesday, May 29, 2019 7:33 AM

Answers

All replies