cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to sort No object table's records?

Former Member
0 Kudos

Hi,

Is it possible to sort the records of No object table that is accessible by clicking Tools-User tables?

by default, it sorts on the basis of the 'code' column but, since it is of character type, the sorting is not numerically correct. it sorts like 1,10,11,12,....19, 2,20,...and so on.

thanks and regards,

Binita Joshi

Accepted Solutions (1)

Accepted Solutions (1)

Nussi
Active Contributor
0 Kudos

Hi Binita,

i know this problem and its weird - you can't sort it.

thats why i generate codes always with 0 before - than it is sorted.

like

00001

00002

...

00011

that's how iam doing.

lg David

Former Member
0 Kudos

David,

Will do for now.

lg,

Binita

Edited by: Binita Joshi on Jun 10, 2008 3:12 PM

Thanks.

Answers (0)