Character to number

[Roland]

I have a Table (donexam) who contains a 10 Character field (Prelx_Rquant) which contains numbers as : 18 21.9 100 102.33

I want to "filter" this numbers and only have the numbers above 100 (or 100.00) to be displayed

How can I do this with the query reporter ?

 

[Marco Kalter]

If you want to suppress records with values smaller than 100:

select ...
where to_number(Prelx_Rquant) >= 100

If you want to display an empty cell for Prelx_Rquant values smaller than 100:

select ...,
       case when to_number(Prelx_Rquant) >= 100 then
         Prelx_Rquant
       else
         null
       end as Prelx_Rquant,
       ...
where ...