Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sort Order Expand / Collapse
Author
Message
Posted Friday, April 18, 2014 3:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 9, 2015 10:27 AM
Points: 59, Visits: 322
Hi,
I have one column in table like code.

The table contains data like:
01
02
03
04
05
04A
05A
06

I need to sort that data in ASC order: out put should be like:
01
02
03
04
04A
05
05A
06

Post #1563196
Posted Friday, April 18, 2014 4:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, July 13, 2015 10:29 AM
Points: 6,897, Visits: 13,551
Something like this?
SELECT [one column] FROM table ORDER BY [one column]





Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1563198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse