Hi Jim,

It's not a bug. The ISNUMERIC() functions returns 1 when the input expression evaluates to a valid integer, floating point number, money or decimal type. The expressions you provide are evaluate to an integer( '+' an "-") and float ('11d111').

>I used IsNumeric function in SQL server 2000. I found
>
>select isnumeric('-')
>select isnumeric('+')
>
>all return 1.
>
>I search web. somebody said
>
>select IsNumeric('11d111')
>
>return 1.
>
>Will MS fix this in future?