Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ron Moses More fun with ISNUMERIC() RE: More fun with ISNUMERIC()

  • July 7, 2010 at 1:42 pm

    #1189833

    Toreador (7/7/2010)

    that's the bit I can't understand. Does the same not apply to

    isnumeric('1.234,56')

    yet this returns 1?

    I wonder if it's because ISNUMERIC disregards the position of the comma? For instance,

    isnumeric('123,45.7')

    returns 1

    As does

    isnumeric('12345.67,89')

    I also noticed that converting a string of numbers with a comma anywhere in it (e.g., '12,345') to a numeric value results in an error, even though ISNUMERIC returns 1 on that string.