[ic] What is wrong with this numeric search?

[Barry Treahy, Jr.]

Can anyone please take a gander at this and tell me why it is not 
limiting the search to quantities less than 200?

[loop
        prefix=FLY
        search="
                fi=tiers
                st=db
                tf=code
                co=yes
                rf=code,tier,quantity,discount,description
 
                ac=0
                sf=tier
                op=rm
                se=[scratch tier]
 
                nu=1
                sf=quantity
                op=<
                se=200
 
"]

What it appears to be doing is showing me all quantities that begin with 
a character sort value less than two, so I'm seeing all quantities that 
begin with a 1 digit.  Below is also a sample of the said table:

code    tier    quantity        description     discount
00100   T1      1       1 to 9  1.00
00110   T1      10      10 to 24        0.94
00120   T1      25      25 to 49        0.89
00130   T1      50      50 to 99        0.85
00140   T1      100     100 to 199      0.78
00150   T1      200     200 to 499      0.75
00160   T1      500     500 to 999      0.71
00170   T1      1000    1000 to 2499    0.66
00180   T1      2500    2500 to 4999    0.62
00190   T1      5000    5000 to 9999    0.57
00200   T1      10000   10000 to 14999  0.52
00210   T1      15000   15000 to 24999  0.49
00220   T1      25000   25000 to 49999  0.46
00230   T1      50000   50000 to 99999  0.43
00240   T1      100000  100000 +        0.40

I'm sure this is a case of too much coffee and too little sleep, but 
I've got a deadline at the end of this month of goofy things like this 
are driving me nuts... It seems is the simple stuff I'm really getting 
screwed up on...  Anyone?

Barry

-- 

Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO 

E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028