Retrieve numeric records

[Anon]

Hello! I am fairly new to  Cognos and this may be simple but I am unable to crack it.

I have a field which has both numeric and text values which I am bringing in through SQL query. I only want to get the numeric values and I am unable to cast this field to integer and writing a case statement to only give me values greater than 0. Also, because this is an out of the box report and the queries are already built it would be great if there would be a solution where I do not have to create a new query and mess with the multiple query joins. Thanks in advance.