UmaShankar Patel (9/1/2012)
You need to select query as
select * from @NumberTable
order by Convert(numeric,REPLACE(REPLACE(ItemNumber,'ABC-',''),'-xyz','')) asc
Like Ravi said, the "XYZ" portion could change so this won't work.
--Jeff Moden
Change is inevitable... Change for the better is not.