Home Forums SQL Server 2008 SQL Server 2008 - General Arithmetic overflow error converting nvarchar to data type numeric. RE: Arithmetic overflow error converting nvarchar to data type numeric.

  • October 14, 2012 at 2:46 am

    #1548935

    when i run

    select * from table order by price asc

    i get...

    115.50

    36.00

    4.95

    4.95

    4.95

    47.30

    49.50

    49.50

    53.90

    when i should get

    4.95

    4.95

    4.95

    36.00

    47.30

    49.50

    49.50

    53.90

    115.50

    what do i need to change in the sql query ?