Home Forums SQL Server 2008 SQL Server 2008 - General My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric

  • January 16, 2013 at 7:16 am

    #1577812

    or...

    ORDER BY RIGHT(SPACE(20)+BipolarNumbers,20) ASC

    Far away is close at hand in the images of elsewhere.
    Anon.