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, August 27, 2014 9:28 AM
Points: 48, Visits: 273
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: Today @ 3:50 AM
Points: 7,157, Visits: 13,218
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