Convert text to number 1

[kmPremier]

Hello all,
I am using Crystal 7.0
I have a field that is representative of a Category and is actually a numeric Category, but the field is a string field.
What is happening is that I am unable to sort this information in order - ie) it is giving me 1, 10, 11, 2, 23, 5, etc...
Is there any formula that I could use that would convert this to a numeric field so that it would sort properly????

Any help would be greatly appreciated.
Thanks

 

[lbass]

You could use either:

val({table.numericstring})

Or,

tonumber({table.numericstring})

-LB

 

[synapsevampire]

You might also use a SQL Expression so that the database does this rather than Crystal, but this is dependent upon the database used, which you didn't share.

An example for many SQL databases would be:

Cast(table.field as numeric)

This way the database will do all of the work, rather than Crystal, improving performance.

-k

 

[kmPremier]

Thank you so much!
the val({table.numericstring}) worked! I knew it had to be a simple formula, but I couldn't find it anywhere.
Thanks.