Home Forums Article Discussions Article Discussions by Author Discuss content posted by Britt Cluff IsNumeric with NULL and Empty String RE: IsNumeric with NULL and Empty String

  • August 4, 2011 at 7:11 am

    #1363618

    Nice. But try it.

    DECLARE @NumericKey INT

    SET @NumericKey = NULL

    SELECT ISNULL(@NumericKey, 0), IsNumeric(@NumericKey),@NumericKey

    SET @NumericKey = ''

    SELECT ISNULL(@NumericKey, 0), IsNumeric(@NumericKey),@NumericKey

    GO

    DECLARE @NumericKey VARCHAR(30)

    SET @NumericKey = NULL

    SELECT ISNULL(@NumericKey, 0), IsNumeric(@NumericKey),@NumericKey

    SET @NumericKey = ''

    SELECT ISNULL(@NumericKey, 0), IsNumeric(@NumericKey),@NumericKey