Home Forums SQL Server 2008 SQL Server 2008 - General ORDER BY- Decimal/hyphen - HELP NEEDED!! RE: ORDER BY- Decimal/hyphen - HELP NEEDED!!

  • August 28, 2015 at 2:56 pm

    #1823161

    SELECT * FROM #SampleData

    ORDER BY CAST( REPLACE( num, ':', '.') as decimal(12, 3))

    This worked perfect. Thanks SO much.