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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 1:54 PM
Points: 46, Visits: 252
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: 2 days ago @ 1:11 PM
Points: 7,019, Visits: 12,909
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