help with formula

[SDeLa131]

trying to create a formula for pulling only orders that do not have 000 as the ending factor.  The field is only 3 characters long but yet each formula I try still pulling orders that have 000.  

example is backorderNu > 000   is really what I need nothing fancy. 

[vishsaggi]

Try this?

Trim(backOrderNu) > 000

Is this field numeric or char? 

or 

Trim(BackOrderNu) <> '000'

[bharathadde]

if you want to limit data on the script level

Load

Ordernum

from table

where not WildMatch(OrderNum,'*000') ;