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?


Thanks


Jim




select isnumeric('-')