Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunil Chandurkar What will be output? RE: What will be output?

  • March 25, 2010 at 2:32 pm

    #1140005

    vk-kirov (3/25/2010)

    Hugo Kornelis (3/25/2010)

    ' ' is converted to the value 0 (run [font="Courier New"]SELECT CAST(' ' AS int);[/font] if you don't believe me).

    This is very interesting because [font="Courier New"]ISNUMERIC(' ')[/font] returns 0.

    On the one hand, SQL Server doesn't consider whitespaces as numeric values; on the other hand, it converts whitespaces to zero integer values. This is a little bit strange 🙂

    This is consistent with the explanation though. It is not considered a numeric until is implicitly converted through a numeric operation with a numeric operand. So, ISNUMERIC(' ') will return 0, but ISNUMERIC(' ' + @a + 2) will return 1.