I want to group the record co_id in the following way

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

[KH] SSCommitted Points: 1908 More actions · Answer 1

looks like your co_id is char / varchar.

as the ascii code for space (' ') (Ascii 32) is smaller than zero ('0') (Ascii 48), it will be ordered that way

if you can alter the table structure, try adding another integer column and set the value of the column to your desired ordering sequence

Donald Sawford SSCrazy Points: 2778 More actions · Answer 2

Since it seems to be char or varchar, if field only stores numeric values, the following might give the results you want:

select * from testid order by rtrim(co_id) + 'ZZZZZ'

If it can contain alpha, this would have to be adjusted.

Saiju SSC Journeyman Points: 78 More actions · Answer 3

Thank You Very much ......

It is working

Saiju Thomas

[KH] SSCommitted Points: 1908 More actions · Answer 4

SSCommitted

Points: 1908

October 31, 2005 at 4:57 am

Good Idea !

Donald Sawford SSCrazy Points: 2778 More actions · Answer 5

SSCrazy

Points: 2778

October 31, 2005 at 5:49 am

You're welcome.

I'm glad it worked for you.