Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    11

    Post Unanswered: Truncating a value with many decimal places

    Hi All,

    I am having this value in a field. It has got 42 decimal places.

    .007117792138823152340064886741230745315904

    Is it possible to truncate the value to 38 decimal places ?

    Thanks
    Samuel Schwartz

  2. #2
    Join Date
    Jul 2003
    Posts
    9

    Re: Truncating a value with many decimal places

    Might you try:

    TRUNC(.007117792138823152340064886741230745315904, 38)

    Thanks!

  3. #3
    Join Date
    Feb 2002
    Location
    India
    Posts
    11
    Thanks Kinsun. It's working fine !!

    Regards,
    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •