14
bp85
8y

SQL Server - ISNUMERIC(',') returns 1. A COMMA IS NOT NUMERIC!!

Comments
  • 0
    It is numeric. For example, 1,5 is one and a half.

    However, that don't mean you can convert it, as a lone comma is a incomplete number.
  • 0
    @sebastian Exactly, ',' on its own is not numeric!
  • 1
    @bp85 : ISNUMERIC propably is eqivalient to something like m/\-?[0-9.,]*/
  • 1
    @DutchmanDavid SQL may take the biscuit for useless error messages. "blah blah near '.'" being a prime example
Add Comment