"Not Match" isn't working

[mapratt82]

I can't get the following to work:

  If((

     (Rate_Index = 02 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000, 0.002000, 0.003000)) or             

     (Rate_Index = 03 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000)) or

     (Rate_Index = 04 and Not Wildmatch(Interest_Rate, 0.001000, 0.002000, 0.003000, 0.005000)) or

     (Rate_Index = 07 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000)) or

     (Rate_Index = 08 and Not Wildmatch(Interest_Rate, 0.001000)) or

     (Rate_Index = 13 and Not Wildmatch(Interest_Rate, 0.010000, 0.001500)) or

     (Rate_Index = 34 and Not Wildmatch(Interest_Rate, 0.001000, 0.003000))), 1, 0) as Error_Interest_Rate,

I have this in the Load statement. I have tried using " ' " doesn't help. It appears to give everything a '1', regardless of Interest_Rate.

Thanks

[mapratt82]

That makes sense, unfortunately I'm not allowed to upload any data.

[Anonymous]

you're not allowed to upload 10 rows of the fields Rate_Index and Interest_Rate?!?

[mapratt82]

LOL I meant my employer. They are really strict, I was luck to get them to let me post what I did.