Re: Changing Ordering

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 02 Feb 2006 22:12:03 +0100

On Thu, 2 Feb 2006 02:11:27 -0800, Sian wrote:

Not quite sure how to word this.

Is there any way to change the ordering of SQL Server
I need it to order

ABC2 then ABC12 then ABC110 (this is by entire string, rather than
individual characters)

currently it orders it ABC110, ABC12, ABC2

is there anyway we can change this?

Hi Sian,

ORDER BY ColumnName DESC

?

--
Hugo Kornelis, SQL Server MVP
.

Follow-Ups:
- Re: Changing Ordering
  - From: Sian

Next by Date: Re: Selecting data from one table based on conditions in another table
Next by thread: Re: Changing Ordering
Index(es):
- Date
- Thread

Relevant Pages

Re: Case help and Identity help
... Hugo Kornelis writes: ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: SQL Minus 7 days from current date
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(microsoft.public.sqlserver.mseq)
Re: Extracting the table names to which a fied is related to
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(microsoft.public.sqlserver.mseq)
Re: Create One Trigger For Both Update and Delete
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: How to debug in SQL Server 2005
... SQL Server 2005 only supports debugging from Visual Studio. ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)