is it possible to change from a varchar to an integer of data from a database?

Well the problem I have is like this, the first is that I do not have access to the database, and the main problem is, I get from this database, data, it turns out that when I get a column with values, they do not respect the numerical order, for example; 1,11,132,145,186,2,22,234,257,3,4. that is an example, it only respects the first digit to the left. Another thing I noticed is that in the db, they use varchars instead of an integer, my question is, if I can not access the database, is it possible to change by means of a filter, or by means of some expression the format? I already tried to call my recordtype, with a cast, but it sends me an error when I do it from my recordlist for filters.

for example

tointeger(recordtypebdd.fields.values) and I get an error...

I hope you can help me.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data