Home Forums SQL Server 2008 T-SQL (SS2K8) ORDER BY PROBLEM RE: ORDER BY PROBLEM

  • September 1, 2012 at 4:03 am

    #1532674

    You need to select query as

    select * from @NumberTable

    order by Convert(numeric,REPLACE(REPLACE(ItemNumber,'ABC-',''),'-xyz','')) asc

    Thanks.......
    -----------------------------------
    My Blog[/url] | Articles