• kevin.l.williams (8/7/2009)


    isnumeric is just evaluating valid characters.

    This will produce 1 also

    select isnumeric('-$,')

    Hi Kevin,

    I think that is not true.

    Try select isnumeric('$$') for example.

    It will evaluate to false, although this character ($) was no issue in your previous example.

    The reason why your example is returning true, is probably the fact that it can be cast to (small)money.

    Try finding an example that is not convertible to a numeric datatype but that returns true in this function.

    Best Regards,

    Chris Büttner