SAP Knowledge Base Article - Preview

2053654 - ISNUMERIC() function returns incorrect result of '1' for various characters and empty string - SAP ASE

Symptom

  • Using the ISNUMERIC() function with the following character strings incorrectly returns a value of '1' :
    • .  (period)
    • ,  (comma)
    • $ (currency sign)
    • + (plus sign)
    • -  (minus sign)
    • e (natural logarithm)
    • "" (empty string)
  • The attempt to convert the above, apart from the empty string, to a 'number' datatype of types integer, float, money, decimal or numeric, fails with error 249:

Msg 249, Level 16, State 1:
Syntax error during explicit conversion of VARCHAR value 'e' to a FLOAT field.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.x and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

conversion ,VARCHAR,INT field , error 249 , message 249 , 'incorrect result' , 'incorrect conversion' , "empty string" , ("") , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.