Home Forums Article Discussions Article Discussions by Author Discuss content posted by William Talada IsNumber fails cast while IsBigInt passes cast RE: IsNumber fails cast while IsBigInt passes cast

  • June 11, 2010 at 8:12 am

    #1179203

    For character type strings you expect to be integers, there's also

    ISNUMERIC(RTRIM(@value) + '.0e0')