Home Forums SQL Server 7,2000 T-SQL Error converting data type nvarchar to float RE: Error converting data type nvarchar to float

  • Hi Sergiy,

    I have just tested your code but the same error message appiers.

    When I use whole number e.g. 15 there is not problem, but if I use e.g. 15,28

    appiers error message.

    ALTER Procedure dbo.UpdateTB

    @e_Nplan char(20), /* e.g. 112e */

    @e_Ncas char(20) /* e.g. 15,28 */

    As

    Update Cis_OP_NO

    SET N_Cas100ks = CONVERT(float(2) , LTRIM(RTRIM(@e_Ncas)))

    Where N_Kplan = @e_Nplan

    return

    Thanks