How to separate number from text inside a table?

[#1]

Hi!

I come to you now with this little problem, I need to know how to set a where statement inside a table to indicate a separation between numbers and text inside a single column.

That is a where after I have loaded a table, I am thinking in something like: "where isnumber(dimension)", although I don't really know if "isnumber" exists, but it would be something in that area.

Thank you again for your help, and have a good day.

[#2 · Accepted solution]

If someone out there is wondering, the expression isnumber does not exists, but isnum does, and works just fine to solve this issue.

[Chanty4u]

can u share sample