Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    3

    Unanswered: SQL syntax error

    Hello, i am new to Informix and I am trying to write a SQL statement but I am getting the following error:

    1213: Character to numeric conversion error

    Here is the SQL and the ROUND function in bold red is causing the issue. i tried to do a conversion, but it does not help. Any ideas?
    Last edited by HDNightster; 03-01-11 at 16:40.

  2. #2
    Join Date
    Mar 2011
    Posts
    3
    Okay, this turned out to be a data issue. I modified the case statements to cover all the scenarios
    Last edited by HDNightster; 03-01-11 at 16:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •