Post reply

ISNUMERIC() question

  • December 10, 2010 at 9:21 am

    #104016

    Greetings. Does anyone have any idea why the below would return true?

    SELECT ISNUMERIC(' ,')

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • December 10, 2010 at 9:32 am

    #1261111

    Greg Snidow (12/10/2010)

    Greetings. Does anyone have any idea why the below would return true?

    SELECT ISNUMERIC(' ,')

    Check out this article[/url]

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • December 10, 2010 at 11:34 am

    #1261157

    Very interesting. Now I am thinking of all the stuff I am going to have to fix, now that I know what not to do. Thanks for the tip, and thanks to Jeff for the great article.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply