<div>
Another work around for this...<br />
<br />
You can copy this data to a temporary table where you actually declare this column as varchar and sort it based on the column..<br />
<br />
or else<br />
<br />
select * from testtest order by convert(varchar(2000),test<wbr />2) --in the order by ..do an explicit conversion as I shown in the query
</div>


Another work around for this...

You can copy this data to a temporary table where you actually declare this column as varchar and sort it based on the column..

or else

select * from testtest order by convert(varchar(2000),test2) --in the order by ..do an explicit conversion as I shown in the query

<div>
Try this:<br />
<br />
SELECT * FROM ...some table... ORDER BY cast(something as nvarchar(4000))<br />

</div>


Try this:

SELECT * FROM ...some table... ORDER BY cast(something as nvarchar(4000))


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using SQL CE 2.0 and have an ntext field which I need to sort. &nbsp;Due to integration issues, unfortunately ntext is all I am allowed to use. &nbsp;I am having difficulty sorting it though... when I use:<br />
<br />
SELECT * FROM ...some table... ORDER BY ...something...<br />
<br />
I get an error, and when I looked on the net, aparently ntext cant be sorted. &nbsp; Does anyone know of a solution to this...?<br />
<br />
Thanks guys.
</div>
</div>


Hi,

I am using SQL CE 2.0 and have an ntext field which I need to sort.  Due to integration issues, unfortunately ntext is all I am allowed to use.  I am having difficulty sorting it though... when I use:

SELECT * FROM ...some table... ORDER BY ...something...

I get an error, and when I looked on the net, aparently ntext cant be sorted.   Does anyone know of a solution to this...?

Thanks guys.

Sort ntext

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.