Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amol Naik Numeric or Not Numeric RE: Numeric or Not Numeric

  • February 22, 2010 at 3:24 am

    #1122807

    Good Question:

    Also

    DECLARE @PrincipalAmount VARCHAR(15)

    SET @PrincipalAmount = '£700,000'

    SELECT ISNUMERIC(@PrincipalAmount)

    returns 1 as does

    DECLARE @PrincipalAmount VARCHAR(15)

    SET @PrincipalAmount = '$700,000'

    SELECT ISNUMERIC(@PrincipalAmount)

    See http://msdn.microsoft.com/en-us/library/ms188688.aspx for other recognised currency symbols

    RedLlewy
    "The Plural of Anecdote is not Data"