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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-31 : 18:51:54
|
| Saiju writes "I want to group the record co_id in the following wayco_id 101102103120120220323013023033But i am getting it this orderco_id 110110210322012022033301302303" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-31 : 19:46:49
|
order by case when len(co_id) = 1 then '0' else '1' end + convert(varchar(10), co_id)Go with the flow & have fun! Else fight the flow  |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-31 : 20:34:42
|
| orORDER BY co_id + '9999999' |
|
|
|
|
|
|
Grouping records in a particular way