Sorry, my typo, I should have cut and pasted. Really it is this :

lx = "Zip Code"
ly = "Zip"
at(ly,lx) 

returns 0 instead of 1

INSERT INTO test1 (test1) VALUES ("My US based Zip Code")
AT("Zip",(test1.test1) 

returns 0 instead of 16.

Thanks,

>>
>>

>>I asked about this once before a while back, and nobody seemed to have heard about, but I was too busy to check it out.
>>
>>The AT() command frequently and consistantly returns 0 when it should not.
>>
>>lx = "Zip Code"
>>ly = "Zip"
>>at(lx,ly) returns 0 instead of 1
>>
>>or
>>
>>INSERT INTO test1 (test1) VALUES ("My US based Zip Code")
>>AT(test1.test1,"Zip") returns 0 instead of 16.
>>
>>
>>Anyone?
>
>You have the parameters in the wrong order. Your first example should be:
>
>...
>? at(ly, lx)
>...