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
- Re: Changing Ordering
- Next by Date: Re: Selecting data from one table based on conditions in another table
- Next by thread: Re: Changing Ordering
- Index(es):
Relevant Pages
|
|