Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | Ralph39Starting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2014-06-20 : 13:38:23 
 |  
                                            | I have a SQL table with part numbers in nvchar datatype that I would like to display on my webpage in a logical order. They look like PT-002-1043, T-899, or CIP-432A,B,or C. Currently I only 'Order By' the tank volumes so the part numbers are all jumbled. Any ideas would be helpful. Thanks |  |  
                                    | gbrittonMaster Smack Fu Yak Hacker
 
 
                                    2780 Posts | 
                                        
                                          |  Posted - 2014-06-20 : 14:56:02 
 |  
                                          | let's see some sample rows and how you'd like it to appear |  
                                          |  |  |  
                                |  |  |  |