Home Forums SQL Server 2005 SQL Server 2005 General Discussion isnumeric issue RE: isnumeric issue

  • June 16, 2010 at 5:37 am

    #1180873

    but when I tried to use the below query

    IF ISNUMERIC('$123432345')=1

    SET @profile = 'NUMBER'

    ELSE

    SET @profile = 'CHAR'

    SELECT @profile

    it is also returning number even though its having $ character.

    Please help