Hi all,

can i sort a field with domain string, that contains only numbers, like it was a Number field?
Now it is sorted like ==> 1,11,..etc.

It is possible in other ways other than change the domain?
Thanks

I mean i've to sort that field when i see records in ttaad..

Thanks in advance

Hello,
a numeric string can be handled with val or lval

function double val (string expr)

Description

This function converts the supplied textual representation to the represented floating point value or to the floating point value corresponding to the represented integer value


val - double
lval - integer

Regards

Thanks, but this is not solving my problem. As u can see in my last reply i've this problem with records in table fields, not with a variable.

Thanks

Hi,

the only way I can think of is to zero fill the numbers: 001, 011, 100 instead of 1, 11 and 100. I don't think there is any other way :rolleyes:

Thank you @vahdani, i will try this solution...if i don't solve even with this, i will try to change the domain in an integer one..

Thank you!