<div>
order by cast(right(fieldname, 3) as int) asc
</div>


order by cast(right(fieldname, 3) as int) asc

<div>
<div class="content wysiwyg-content">
in SQL Server 2005, how do we sort this nvarchar field <br />
<br />
SO204750000000011<br />
SO50340000000001<br />
SO53000000000002<br />
SO68190000000003<br />
<br />
so it will become <br />
<br />
SO50340000000001<br />
SO53000000000002<br />
SO68190000000003<br />
SO204750000000011
</div>
</div>


in SQL Server 2005, how do we sort this nvarchar field 

SO204750000000011
SO50340000000001
SO53000000000002
SO68190000000003

so it will become 

SO50340000000001
SO53000000000002
SO68190000000003
SO204750000000011

Sort nvarchar in SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.