Results 1 to 3 of 3

Thread: 0.9 and .9

  1. #1
    Join Date
    May 2003
    Location
    Edmonton Alberta Canada
    Posts
    41

    Unanswered: 0.9 and .9

    Hi, I thought .9 is not a valid number, but though I should do this just as a favor for the client. Before I had

    TO_NUMBER('mort_percent', 'FM99990.00').

    So what kind of change should I make, or .9 is not a valid number after all.

    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Exclamation

    Try this:

    TO_NUMBER(mort_percent, 'FM99999.00').



    NOTE: I assume the quotes in 'mort_percent' is a typo.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    May 2003
    Location
    Edmonton Alberta Canada
    Posts
    41
    Yes. It's a typo results from copy and paste from the externalised sql.xml file.

    Thanks!

Posting Permissions

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