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:58 am

    #1577827

    David Burrows (1/16/2013)

    or...

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

    I was thinking something like that. Didn't get as far as actually writing (or testing) it though 🙂