Post reply

Insert a numeric value with decimal

  • June 14, 2007 at 8:47 am

    #117504

    Is there anyone that has a solution to my problem.

    INSERT test VALUES ('ABC', 50,9)

    The table has a field declared as numeric, insert works if there is no decimal sign.

    50 is ok but not 50,9.

    Help please

     

     

  • June 14, 2007 at 8:55 am

    #712974

    I imagine that it's being interpreted as three values: ABC, 50, and 9.  What error message are you getting?

    John

  • June 14, 2007 at 8:56 am

    #712975

    Since you did not post the table definition, nor the actual error message it is very difficult to help.  The following test code works fine under my SQL 2000 SP4:

    create

    table t1 (col1 char(3), col2 numeric, col3 numeric)

    insert

    into t1 values ('abc',50,9)

    insert

    into t1 values ('abc',50,9.)

    IF your are trying to insert the value 50.9 then use a "period" for the seperator not a comma.  Otherwise Please provide additional information to help us help you.

  • June 14, 2007 at 3:47 pm

    #713065

    Thanks, using a period was the solution.

    Now I can insert 50.9.

     

    / Rolf

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply