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 |  
                                    | skylimitsqlStarting Member
 
 
                                        8 Posts | 
                                            
                                            |  Posted - 2010-09-02 : 07:26:32 
 |  
                                            | Please help me in building this select statementI need to control it rather then hard code.Result should be like this --0xx1xx2xx3xx4xx5xx6xx7xx8xx9xxThen AxxBxxCxxDxxFxxThen 0xx1xx2xx3xx4xx5xx6xx7xx8xx9xxThen Axx........FxxThen oxx......9xxSo First 0xx - 9xx then Axx - Fxx then again 0xx - 9xx then again Axx-FxxThanks |  |  
                                    | madhivananPremature Yak Congratulator
 
 
                                    22864 Posts | 
                                        
                                          |  Posted - 2010-09-02 : 09:02:20 
 |  
                                          | http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149636MadhivananFailing to plan is Planning to fail |  
                                          |  |  |  
                                |  |  |  |