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 |
|
nuni2j
Starting Member
1 Post |
 Posted - 2008-07-21 : 00:22:59
|
| Hi,I have a columns that look like this in the table:Task Name Outline NumberWork 1 In-house 1.1 External 1.2Play 2 Drinking 2.1 Sport 2.3I would like to sort my results by the Outline Number column which contains text fields. When you have so many tasks that you reach 10.1 then the sort is all wrong as the 10 comes directly after the 1. Do you know how i could alter the Outline number field so i can pad the number with 0's for example 10.1.3 would be 0010.0001.0003 as this would ensure the correct order is always displayed.Thanks,Ananda |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Sorting